Posted to microsoft.public.excel.worksheet.functions

Access Joe Access Joe is offline

external usenet poster

Posts: 54

How to extract just text from cells

Hi all,

I want to extract only TEXT from a column of numbers and text. For example:

WHAT I HAVE:
150mgdl
2000mg
10mgdl
500cc

WHAT I WANT:
mgdl
mg
mgdl
cc

is there a function in Excel that does this and extracts only the text, not
the numbers?

Thanks everyone!

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
Need to extract certain text from text string	Trista @ Pacific	Excel Worksheet Functions	4	November 21st 07 07:07 PM
Extract text from large Text	ldiaz	Excel Discussion (Misc queries)	4	November 14th 07 01:21 AM
Text Extract	Arturo	Excel Worksheet Functions	1	December 12th 05 04:24 PM
EXTRACT TEXT FROM TEXT STRING	carricka	Excel Worksheet Functions	4	July 8th 05 11:00 AM
Extract text	someone	Excel Worksheet Functions	12	January 23rd 05 12:24 AM

All times are GMT +1. The time now is 05:15 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us