Posted to microsoft.public.excel.worksheet.functions

Martina

external usenet poster

Posts: 25

Extraction

Dear Experts,
I have one cell which contains the following string of characters exactly in
this format:

Smith, Jane (jc162964) | 0616025915

Can I use excel to extract the last ten digits and put them into another cell
AND
Can I use excel to extract the Smith, Jane part into another cell?
regards
Martina

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
Extraction Question	maperalia	Excel Discussion (Misc queries)	14	December 17th 06 03:32 AM
Word Extraction	A.S.	Excel Discussion (Misc queries)	3	May 5th 06 06:27 PM
data extraction	TUNGANA KURMA RAJU	Excel Discussion (Misc queries)	10	February 27th 06 12:25 PM
data extraction	Usul	New Users to Excel	1	February 16th 06 04:04 AM
Data Extraction	Chicken Man	Setting up and Configuration of Excel	1	February 24th 05 03:13 AM

All times are GMT +1. The time now is 06:35 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us