Oh God the Pain! Help Please!

[jshpik1]

Hey,

OK here's my problem. I have 1 cell with something like this: XXXX
YYYYY. It's alphanumeric (has some numbers and a letter). I need t
format this to look like XXXXXXX in 1 cell, and then YYYYYY in the cel
to the right of that. I need to do this for thousands of cells i
thousands of rows..... Please tell me there's an easier way to do thi
than going into each cell and copy then paste into the cell next to it
Thanks

 

[David Biddulph]

Hey,

OK here's my problem. I have 1 cell with something like this: XXXXX
YYYYY. It's alphanumeric (has some numbers and a letter). I need to
format this to look like XXXXXXX in 1 cell, and then YYYYYY in the cell
to the right of that. I need to do this for thousands of cells in
thousands of rows..... Please tell me there's an easier way to do this
than going into each cell and copy then paste into the cell next to it.
Thanks!

If that's a space between your Xs and your Ys, then Data/ Text to columns/
Delimited/ Space

 

[jshpik1]

Wow, that was easy. Thanks!