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".
i would like delete text and rows respectively also.(other than strating letter "MB" or "SM" and "CY".)
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)