Posted to microsoft.public.excel.worksheet.functions

Dan S

external usenet poster

Posts: 5

Stripping nubers from text in a cell

I have a bunch of cell with varying lench that have numbers at the beginning
(also of varying length. Ex:

1258 ahjKJ yuUIOI
45687045HJKoiuwER

I just want to extract the text from these cell. How do I do that?

Thanks,
Dan

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
Stripping text from numbers in a cell	Michael M	Excel Worksheet Functions	10	July 13th 07 03:47 PM
Stripping text before a number (alpha or numeric)	data_mattress	Excel Worksheet Functions	10	April 12th 06 02:19 AM
Add numbers accross columns after stripping away text	gavin	Excel Discussion (Misc queries)	10	May 23rd 05 07:50 PM
Stripping section of text	Philippe L. Balmanno	Excel Worksheet Functions	3	December 30th 04 03:36 PM
Stripping mixed number and text	Kevin	Excel Worksheet Functions	2	December 9th 04 05:49 PM

All times are GMT +1. The time now is 11:58 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us