software

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!--
jshpik1
------------------------------------------------------------------------
jshpik1's Profile: www.excelforum.com/member.php...oamp;userid=34256
View this thread: www.excelforum.com/showthread...hreadid=540152quot;jshpik1quot; gt; wrote in
message ...
gt;
gt; Hey,
gt;
gt; OK here's my problem. I have 1 cell with something like this: XXXXX
gt; YYYYY. It's alphanumeric (has some numbers and a letter). I need to
gt; format this to look like XXXXXXX in 1 cell, and then YYYYYY in the cell
gt; to the right of that. I need to do this for thousands of cells in
gt; thousands of rows..... Please tell me there's an easier way to do this
gt; than going into each cell and copy then paste into the cell next to it.
gt; Thanks!

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

Wow, that was easy. Thanks!--
jshpik1
------------------------------------------------------------------------
jshpik1's Profile: www.excelforum.com/member.php...oamp;userid=34256
View this thread: www.excelforum.com/showthread...hreadid=540152