6 numbers in one column

[Edo]

6 numbers in one column separated by hyphen. want to put them in separate columns

 

[Aladin Akyurek]

Try...

Data|Text to Columns with hyphen as delimiter.

6 numbers in one column separated by hyphen. want to put them in separate

columns

 

[Domenic]

Hi Edo,

Try using Text to Columns,

1) Select your data
2) Data > Text to Columns
3) Choose Delimited as your Data Type
4) Click Next
5) Check Other as your delimiter and type the hyphen into the box next
to it
6) Click OK/Finish

Hope this helps!

 

[Anders Silven]

Edo,

Try Data>Text to Columns.

HTH
Anders Silven

6 numbers in one column separated by hyphen. want to put them in separate

columns

 

[JE McGimpsey]

Choose Data/Text to Columns. Select the Delimited radio button. Click
next. Check the Other checkbox and insert a hyphen in the textbox. Click
Finish.

 

[Edo]

Thanx I had to do some juggling around, but it worked

 

[Edo]

Thanx I had to do some juggling around, but it worked

 

[Edo]

Thanx I had to do some juggling around, but it worked

 

[Edo]

Thanx I had to do some juggling around, but it worked