STRIP CHARACTERS
Hi,
This works but there may be (surely is) something simpler.
With your string in A1 put these formula in B1, C1 and D1 respictively.
=LEFT(A1,SEARCH("x",A1,1)-1)
=MID(A1,SEARCH("x",A1,LEN(B1))+1,(SEARCH("x",A1,SE ARCH("x",A1,LEN(B1))+1)-1)-SEARCH("x",A1,1))
=RIGHT(A1,LEN(A1)-((SEARCH("x",A1,SEARCH("x",A1,LEN(B1))+1)-1)+1))
Mike
"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?
|