Posted to microsoft.public.excel.programming

Bob Zimski Bob Zimski is offline

external usenet poster

Posts: 30

Parsing a cell's value

I have a cell which contains a part number and a revision level in the format
'ARD010 Rev: 2'. I need to drop the 'Rev: 2' portion in the cell to the
right and the existing cell needs to end up with 'ARD010' without any spaces.

Any help appreciated.

Bob

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
Parsing	Saxman[_2_]	Excel Discussion (Misc queries)	3	July 30th 07 04:36 PM
Instead of Parsing	Krish	Excel Discussion (Misc queries)	1	November 4th 06 08:32 PM
cell's reference value dependent on another cell's value	Flash in the Pan	Excel Programming	4	April 6th 06 09:23 PM
How do I make a cell's contents equal to another cell's contents with macro program?	mgmcdevitt[_10_]	Excel Programming	2	September 15th 05 09:44 PM
Parsing help	Richard[_12_]	Excel Programming	0	July 27th 03 12:50 PM

All times are GMT +1. The time now is 08:46 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us