Hi,
I would like to separate the following list from one column into three columns.
here is the structure of the given list:
- first part of characters are always numeric, but they could have a different length
- second part is always Chinese characters and they also have a different length
- third part is always a number with multiple decimals
I think that one idea would be to insert a blank space between the three parts and then do Text to Columns Delimited by " ".
is it possible to achieve this just using Excel formulas?
Thanks,
Cristian.
I would like to separate the following list from one column into three columns.
GL#/GL Name/Amount - Header |
10001收入0.5894 |
100011销售成本98.4578 |
- first part of characters are always numeric, but they could have a different length
- second part is always Chinese characters and they also have a different length
- third part is always a number with multiple decimals
I think that one idea would be to insert a blank space between the three parts and then do Text to Columns Delimited by " ".
is it possible to achieve this just using Excel formulas?
Thanks,
Cristian.