Search : in
By :

EXcel Del text - other than-start letters MB

Last answer on Mar 21, 2009 7:01:28 am GMT anand, on Mar 20, 2009 6:18:31 am GMT 
 Report this message to moderators

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

Configuration: Windows 2000
Internet Explorer 6.0

Best answers for « EXcel Del text other than start letters MB » in :
IF statements in Excel Show
Capitalize the 1st letter of each word Show Capitalize the 1st letter of each word Below are two ways to proceed: Method 1 sed-r 's /(^.|.) / \ U & / g' Method 2 sed 's / ^. \ | [a-z] / \ U & / g' Method 3 sed-r 's / \
[Excel]changing cell formula to text Show [Excel]changing cell formula to text Issue Solution Notes Issue Consider that I have: In cell A4, it contains a formula =Sum(A1:B3)+A3/B2. How to extract this formula in cell A6 as a string of text? That is ... I want cell A6...
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
[MySQL]Loading a text file into ue table Show[MySQL]Loading a text file into ue table To load a text file as follows: $ tail /home/user1/test.txt 'name1',1,9 'name2',2,3 'name3',3,54 'name4',4,2 'name5',5,9 In a table defined as follows: CREATE TABLE...
Disable Ctfmon.exe at startup ShowDisable Ctfmon.exe at startup Disable advanced text services Disable Ctfmon.exe at startup Additional information The ctfmon.exe is a Windows generic process for managing entries alternative text input software such as voice...
Download Scribes Report Builder ShowScribes Report Builder is a report generator for databases Firebird, Interbase, PostGre-Sql, Sybase, SqlLite, Mysql, Oracle, Microsoft Access, Microsoft SQL Server, Excel databases, text files or the ODBC connections. Its main features are: -...
Download Grab Text ShowDescription The application is designed by GrabText.com. So far it has won many awards from some places and it is also well known worldwide, even being used in companies. Grab Text is a tool that is based on text recognition. The application allows...
Spreadsheets - The Excel Interface ShowExcel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...
Ask your question Reply

1

 password00, on Mar 21, 2009 7:01:28 am GMT

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)

   
Reply to password00
Ask your question Reply
They need your help