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

Question

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

Report

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

EXcel Del text - other than-start letters MB
Excel opens multiple files when starting ✓ - Forum - Excel
Letter dispatch register format in excel free download - Forum - Office Software
Excel letter grade formula - How-To - Excel
Change Excel Column Index From Letter to Number - How-To - Excel
Excel - Set first letter in uppercase - How-To - Excel

1 reply

Ask a question

password00 · Accepted Answer · 2009-03-21T03:01:28-0400

Answer 1 / 1

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)

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

1 reply

Your reply

Subscribe To Our Newsletter!