Taking a look at your Problem 1.
Before doing the following - work with or backup your file.
Select the spreadsheet and then select a "Courier" Font - and then
"Right Justify" this will line stuff up a little better for you. for
the right justify you might have to select "VIEW" - TOOLBARS -
FORMATING.
Insert about 4-5 columns between column A and B - as you will need
"blank" columns for the next step.
Select column A and then on the MENU Bar - Select DATA - TEXT TO
COLUMNS - FIXED WIDTH and then follow the directions. This will
separate your Column A into separate columns.
Then do the same for your "OLD" Column B


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=503725