Posted to microsoft.public.excel.worksheet.functions

Benjamin

external usenet poster

Posts: 102

How do I strip just numbers from an alphanumeric cell?

I need to strip just the numbers after the last -
RV01-HYC0246-43-T-892A i.e. 892
RV01-HYC0246-43-H-892 i.e. 892
I know how to use the Right(and find("")) commands.
Any help on just numeric character and not alphas?

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
separating numbers from a alphanumeric cell	Igneshwara reddy[_2_]	Excel Worksheet Functions	3	March 12th 07 08:13 PM
extract numbers from a alphanumeric cell	Igneshwara reddy	Excel Worksheet Functions	4	February 27th 07 06:24 PM
Function to extract numbers from an alphanumeric cell	diana	Excel Worksheet Functions	4	March 13th 06 09:55 AM
separating numbers and letters from alphanumeric cell contents	PH	Excel Worksheet Functions	10	September 3rd 05 12:15 PM
Sorting alphanumeric numbers	maurice.centner	Excel Discussion (Misc queries)	2	May 6th 05 02:00 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us