I'm having some problems with my formula and am hoping you can help.

This is my formula:

```=IFERROR(REPLACE(F7, FIND("BOB",A2), 13, "Other"),A2)
```

I have 3 names in my data (Column B):

• Bob
• Sarah
• Lee

The name "Bob" should be located and returned in column C as "Other," and I also want Sarah and Lee to be returned as Sarah and Lee, respectively. I'm not sure why, but my formula now returns everyone's name as "Open."

Have any suggestions?

Oct 20, 2022 in Others 284 views

## 1 answer to this question.

Use:

```=IF(ISNUMBER(FIND("Bob",A2)),"Other",A2)
```

Remember FIND is an exact match while SEARCH does not care about the case.

So if Bob can be BOB and Bob then you may want to use SEARCH.

`=IF(ISNUMBER(SEARCH("Bob",A2)),"Other",A2)`
answered Oct 20, 2022 by
• 63,420 points

## IF function in combination with an Round function Excel

I'm not sure if it is a ...READ MORE

## Excel OFFSET function with a dynamic row argument

The answer is to make "anchor cells" ...READ MORE

## Equivalent of Excel Round function

Here's a sample LINQPad program that demonstrates one way ...READ MORE

## How to use the INDIRECT function in Excel

Try this: =INDEX(INDIRECT(\$A\$1&"!\$1:\$1048576"),MATCH(\$B\$1,INDI ...READ MORE

## Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

## Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

## Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

## IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE