# Formula to change exsiting name to new name

1. ## Formula to change exsiting name to new name

Hi Everyone,

I have an column show as attached image. This list is about 1000++ name of Room.
Can excel formula change the Room consist of "CW" to "CWP", then others will be same room as Name.

Attachment 386647

2. ## Re: Formula to change exsiting name to new name

Here!

Assuming the 1st formula will go in Cell C2

=IF(ISNUMBER(SEARCH("CW",B2)),"CWP",B2)

3. ## Re: Formula to change exsiting name to new name

Change cell reference B2 to your actual cell Reference

=IF(ISNUMBER(SEARCH("CW",B2)),"CWP",B2)

Drag it down...

4. ## Re: Formula to change exsiting name to new name

Could you help to explain it to me?
ISNUMBER means what?

Search CW at B2 then result = CWP, the rest copy?

5. ## Re: Formula to change exsiting name to new name

Okay, I will explain it for you

In Excel we have to read the excel formula's from Inside to Out

SEARCH(find_text,within_text)
SEARCH("CW",B2)

Search will return the position of the text. If the value of find_text is not found, the #VALUE! error value is returned.

using IsNumber() to check whether the returned value of Search() is number or error value. IsNumber() will result True if it is number and False if Search() returns Error.

If(Logical Part (i.e) True/False,Value if True,Value if False)

=IF(ISNUMBER(SEARCH("CW",B2)),"CWP",B2)

6. ## Re: Formula to change exsiting name to new name

I really appreciated it.

7. ## Re: Formula to change exsiting name to new name

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1