Note:

Delimiters: select Other and in the little box to the right type 010 using
the *numeric keypad while holding down the ALT key*

When you type the number code 010, nothing will appear in the little box but
don't worry about that.. That is not a printable character.

Biff

"Biff" wrote in message
...
"Carrguy" wrote in message
...


"Biff" wrote:

Hi!

Use Text to Columns
Delimited by Other
Hold down the ALT key and use the numeric keypad and type 010
Finish

Biff can you elaberate on the text to coloum

You said " I am really good at excel" !!!!!

Ok, step-by-step:

Assume that data is in cell A1.
Make sure the cells to the right are empty or any data in them will be
overwritten.
Select cell A1
Goto the menu DataText to Columns
Select Delimited
Click Next
Delimiters: select Other and in the little box to the right type 010 using
the *numeric keypad while holding down the ALT key*
Then select Finish

Biff