Posted to microsoft.public.excel.worksheet.functions

bosco_yip[_2_] bosco_yip[_2_] is offline

external usenet poster

Posts: 24

Extracting certain text from text string

A1 =Rev.2 Doc-5A - Safety in the Workplace 3/26/04

B1, formula :

=MID(A1,FIND(" -",A1)+3,FIND("/",A1)-FIND(" -",A1)-5)

Regards
Bosco

"Haydie-lady" wrote:

I have a database list that I export into xls monthly. Once pasted in xls the
list is just one column w/ several rows a text string (see below). I need to
extract the description only. Please help. see below

Rev.2 Doc-5A - Safety in the Workplace 3/26/04

all I want to extract into another cell is "Safety in the Workplace"

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Extracting h:mm:ss from text string	Micki	Excel Worksheet Functions	19	January 26th 09 05:26 PM
Extracting text from a string	[email protected]	Excel Worksheet Functions	8	June 2nd 08 10:09 PM
Extracting text from string	Confused	Excel Worksheet Functions	4	February 15th 08 03:34 PM
Extracting text from text string	Emile	Excel Worksheet Functions	3	March 30th 06 08:44 PM
Extracting Text in a string of text	walkerdayle	Excel Discussion (Misc queries)	5	December 19th 05 08:27 PM

All times are GMT +1. The time now is 08:23 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us