Split And Separate Data In To Columns Based On Delimiter Using Text To Column

[msiyab]

Hello People,

I have a simple query regarding separation of Text from Numbers in one cell.

For example, I have a list which includes Name & Tel. number in the following format:

ABC/123
DEF/456
XYZ/1234
ASGDF/11
FHADSSAA/121212
HS/12345

Now, I would like to separate the names from the numbers in such a way that one cell contains the name only and the next cell contains the numbers (without the "/") only like this:


ABC 123
DEF 456
XYZ 1234
ASGDF 11
FHADSSAA 121212
HS 12345

Thanks for helping.

[Admin]

Hi

Try Text To Columns under Data menu.

[msiyab]

Ok now i feel silly.

I have never tried the "Delimited" option before.

[azumi]

Maybe something like this?