Posted to microsoft.public.excel.misc

external usenet poster

Posts: 1,388

Quick/Easy Question?

Using Excel 2003...

I have a worksheet with three columns.
-In the first column I have data containg a name and position #. For
example, Joey Doe 01199.
-In the second column I would like to extra only the numerical values. How
can I do this? For the example above I would like to extract 01199.

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
is there a quick easy way to input time?	typographically challenged	Excel Worksheet Functions	2	April 17th 08 12:22 AM
Is there a quick/easy way to get excel to replace ALL forumulas the numerical result in one step?	[email protected]	Excel Discussion (Misc queries)	2	September 21st 07 12:37 AM
Quick and easy labeling	mmednick	Excel Discussion (Misc queries)	4	December 7th 05 01:12 AM
Quick and easy	chisigs2	Excel Worksheet Functions	2	August 24th 05 08:36 PM
new user with easy question? not easy for me	speakeztruth	New Users to Excel	5	June 3rd 05 09:40 PM

All times are GMT +1. The time now is 04:43 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us