Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 33

STRIP CHARACTERS

I looking for awat to break up a cell into 3 different cells.
I can use 3 different formulas if I have too.
I get data like below

123X324X3333
or
1234x45x4343

The amount of numbers may vary abd the X may be x or X.
I can get te first set of numbers with
=LEFT(Q10,MATCH(FALSE,ISNUMBER(-MID(Q10,ROW(INDIRECT("1:8")),
1)),FALSE)-1)
But cannot get the middle or end set of numbers,

Any Ideas?

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
Strip text before character	bell23	Excel Worksheet Functions	4	October 29th 05 10:05 AM
Strip Out Time	HeartSA	New Users to Excel	2	October 13th 05 08:39 PM
Strip carriage return, add row	adin	Excel Worksheet Functions	18	April 26th 05 10:03 AM
TAB STRIP	icebreaker914	Excel Discussion (Misc queries)	1	April 16th 05 01:24 PM
tab strip	icebreaker914	New Users to Excel	1	April 16th 05 01:24 PM

All times are GMT +1. The time now is 06:48 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us