Posted to microsoft.public.excel.misc

SakDaddy

Posts: n/a

I want to remove alphas from within a number.

If I have a column of numbers that have 123a4b5c and I want to remove the
"abc" so that the change reads 12345, what is the function I use?

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
2nd attempt ~ complicated formula	Luke	Excel Worksheet Functions	3	November 9th 05 03:33 AM
how do i remove telephone number hyphens from a list in Excel?	Mediazoo	Excel Discussion (Misc queries)	4	November 3rd 05 08:29 PM
Number of labels on X-axis one more than number of values on Y-axi	Gudrun	Charts and Charting in Excel	5	August 26th 05 01:55 PM
duplicate number	Daniell	Excel Discussion (Misc queries)	1	March 16th 05 07:02 PM
Where is DateDiff function in Excel 2002 ?	Nigel Welch	Excel Worksheet Functions	4	March 4th 05 03:18 PM

All times are GMT +1. The time now is 07:36 PM.

About Us

"It's about Microsoft Excel"