ExcelBanter - separate alpabets & nembers

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - separate alpabets & nembers (https://www.excelbanter.com/excel-worksheet-functions/135140-separate-alpabets-nembers.html)

shaqil

separate alpabets & nembers

Hi all,

I have one column in which i have data like this A 121 B or 12 A 9

Now i want to separate them in 3 columns A and 121 and B
or 12 and A and 9.

Any one has any advice.

Thnx

David Biddulph[_2_]

separate alpabets & nembers

Data/ Text to columns/ Delimited by space
--
David Biddulph

"shaqil" wrote in message
oups.com...
Hi all,

I have one column in which i have data like this A 121 B or 12 A 9

Now i want to separate them in 3 columns A and 121 and B
or 12 and A and 9.

Any one has any advice.

Thnx

All times are GMT +1. The time now is 08:33 PM.