|
find text and move it
Hi,
In col. A I have text and numbers. and in col. B,C,D,E,F I have numbers. I'm looking for a macro that looks in Col.A and find texts and move row A,B,C,D,E, F One to the right. thx, ex. A B C D E F G Tom 28 6 8 46 36 896 56 3 2 7 10 Result. A B C D E F G 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 |
find text and move it
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. -- Cheers, Shane Devenshire "saman110 via OfficeKB.com" wrote: Hi, In col. A I have text and numbers. and in col. B,C,D,E,F I have numbers. I'm looking for a macro that looks in Col.A and find texts and move row A,B,C,D,E, F One to the right. thx, ex. A B C D E F G Tom 28 6 8 46 36 896 56 3 2 7 10 Result. A B C D E F G 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 |
find text and move it
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 |
| All times are GMT +1. The time now is 02:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com