Can this be done automatically .I mean once i enter the format i want my
results split up instead of every time using the Text to colum.

"CLR" wrote:

Make sure there are a few blank rows just to the right of our column with the
strings, then highlight that column and do Data TextToColumns Delimited
and set the hyphen as your delimiter.........post back if you have any
trouble, or more questions.........

Vaya con Dios,
Chuck, CABGx3



"Jp" wrote:

I have the following Number format in one row

132-45-69 N.

I want to split the numbers in three different rows like 132 in one row,45
in another and 69 in the third row.

Can this be done in excell