EXcel Del text - other than-start letters MB [Closed]

Report
-
Posts
23
Registration date
Tuesday December 30, 2008
Status
Member
Last seen
June 18, 2009
-
Hello,

Input
Excel file with one column.

Conditions
I would like to delete text other than which is having starting letters of "MB" or "SM" and "CY".(some time more)
In other word delete text other than starting letters "MB" or "SM" and "CY".

Output
i would like delete text and rows respectively also.(other than strating letter "MB" or "SM" and "CY".)

Regrads
Anand

1 reply

Posts
23
Registration date
Tuesday December 30, 2008
Status
Member
Last seen
June 18, 2009
11
hi,
You can use the function SEARCH to find the position of the letters in the text, and then the function LEFT to retrieve only the portion of the text before it.
=LEFT(A1:<how much you have>,SEARCH("<the letters you need to remove>",A1:<how much you have>)-1)
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!