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
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
Here!
Assuming the 1st formula will go in Cell C2
=IF(ISNUMBER(SEARCH("CW",B2)),"CWP",B2)
Cheers!
Deep Dave
Change cell reference B2 to your actual cell Reference
=IF(ISNUMBER(SEARCH("CW",B2)),"CWP",B2)
Drag it down...
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
WOAH!!! your formula are excellent!
Could you help to explain it to me?
ISNUMBER means what?
Search CW at B2 then result = CWP, the rest copy?
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)
Thanks for your explaination.
I really appreciated it.
Glad it Helps!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks