It worked great.

Thank you.


ShaneDevenshire wrote:
Hi,

Really no need for a macro -
1. Select the data in column A
2. Press F5, Special
3. Turn on the Constants option and uncheck Numbers, Logicals, and Errors
then click OK
4. Press Ctrl+Shift++ (plus sign) and choose Shift Cells to Right.

If you need it in a macro, you can record it.

Hi,

[quoted text clipped - 15 lines]
Tom 28 6 8 46 36
896 56 3 2 7 10

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200709/1