Split info in cell

  • Thread starter Thread starter ottok
  • Start date Start date
O

ottok

Hello

I have the following in one cell:
A-B-C-D-E-F

I would like to achive the following:

In separate collums
A-B
B-C
C-D
D-E
E-F

Any hints ?
Thank you,
Ott
 
Assuming an "A" or "B" etc might be actually more than one character in
length, I would do Data > TextToColumns > and use the hypen as the delimiter
to separate all the character(s) out into their individual
columns.........then CONCATENATE them back into the finished columns as
desired and delete the rest........if you have any problem with any of this,
post back and someone will help

Vaya con Dios,
Chuck, CABGx3
 
Back
Top