Posted to microsoft.public.excel.programming

Stuart[_5_] Stuart[_5_] is offline

external usenet poster

Posts: 413

Stripping data

How best to achieve this, please:

data is of the type 999 102A and is the only entry
in a cell.

I would like to strip the data to end up with 2 options,
either 102A or just A.

Regards.

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.576 / Virus Database: 365 - Release Date: 30/01/2004

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
Stripping HTML from data	str8trini	Excel Discussion (Misc queries)	1	September 7th 09 04:25 AM
Excel data stripping	Steve Moss	Excel Discussion (Misc queries)	5	January 20th 09 12:05 PM
Stripping Information	Kent	Excel Discussion (Misc queries)	7	January 11th 08 07:27 PM
Stripping and Conversion.	Rodney	New Users to Excel	28	June 27th 05 05:51 AM
Stripping out non-numeric values from external data source	Eric Rydell	Excel Programming	1	December 30th 03 01:08 AM

All times are GMT +1. The time now is 05:45 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us