Posted to microsoft.public.excel.programming

Gordon[_2_] Gordon[_2_] is offline

external usenet poster

Posts: 211

Challenging Formula

Hi...

I have 4000 entries in column A similar to...

C:\Common Standards Reports\Spare Parts 0606.xls
C:\Common Standards Reports\Steering wheels 110606.xls
C:\Common Standards Reports\yellow paint 22876.xls

I need the corresponding/adjacent cell in column B to strip out the number
string so that said cells read:

0606
110606
22876

Can this be done?

Thanks in advance...

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
Challenging Formula Issue	Alex	Excel Worksheet Functions	1	June 3rd 10 07:56 PM
Challenging formatting formula	robnet	Excel Worksheet Functions	12	July 19th 07 09:27 PM
Answers needed for challenging formula	Sum Limit and marking	Excel Worksheet Functions	16	April 17th 06 12:15 PM
Challenging long ARRAY formula needed - Can this be done?	quartz[_2_]	Excel Programming	7	November 30th 04 04:03 PM
Challenging Formula in VB	Bruce Roberson[_2_]	Excel Programming	7	January 21st 04 12:28 PM

All times are GMT +1. The time now is 01:10 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us