EXcel Del text - other than-start letters MB

Closed
anand - Mar 20, 2009 at 02:18 AM
password00 Posts 23 Registration date Tuesday December 30, 2008 Status Member Last seen June 18, 2009 - Mar 21, 2009 at 03:01 AM
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

password00 Posts 23 Registration date Tuesday December 30, 2008 Status Member Last seen June 18, 2009 11
Mar 21, 2009 at 03:01 AM
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