separeting a string
hello. I have a column where the each cell consists
strings like,
column
----------------
12
3/4
2-7
3b
8/n
L45
I have alot of such cells possible more than 10000
cells in the column. Now i want to separate each string untill not
finding a numeric. For example, for the above cells, i want to have two
such columns:
columns1 columns2
--------------- ---------------
12
3 /4
2 -7
3 b
8 /n
L45
How can i do such a thing? Thanks lot.
|