STRIP CHARACTERS
In xl2003, I would do:
Select the range and change that delimiter to a common character (x is different
from X).
Edit|replace
what: x
with: |
replace all
Then select one column at a time and use:
Data|Text to columns
Delimited by Other (|)
and finish up the wizard.
rpick60 wrote:
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?
--
Dave Peterson
|