Posted to microsoft.public.excel.worksheet.functions

SHANNON

Posts: n/a

How do I extract numbers from a cell with both text and numbers?

Examples:
AA100.10
ANN242.21

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
extract numbers from cell containing text & numbers	[email protected]	Excel Worksheet Functions	1	November 14th 05 07:04 AM
text and numbers same cell and formulas still work (like lotus)	rmoore	Excel Worksheet Functions	4	July 20th 05 07:02 PM
Format a cell with numbers and user defined text	Rod R.	Excel Discussion (Misc queries)	0	March 30th 05 04:31 PM
Converting Numbers to Text properly	Shirley Munro	Excel Discussion (Misc queries)	1	February 16th 05 03:01 PM
GET.CELL	Biff	Excel Worksheet Functions	2	November 24th 04 07:16 PM

All times are GMT +1. The time now is 12:29 PM.

About Us

"It's about Microsoft Excel"