Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transfer to adjacent columns
Hi
In column A I have a long list that was originally in 4 columns and without separators for the old columns, ie Basingstoke & Deane £644 £1,140 +77% The last 3 are all in the same format but the names vary in size. Is it possible to write a macro to transfer the % to col 4, the 2nd £ amount to col 3, the 1st £ amount to col 2 and leave the names in col A? -- TIA Tim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add cells on two adjacent rows but non-adjacent columns | Excel Worksheet Functions | |||
AUTOFILTER-2 non-adjacent columns | New Users to Excel | |||
How to keep data in two adjacent columns together | New Users to Excel | |||
combining adjacent columns | Excel Discussion (Misc queries) | |||
Printing non-adjacent columns | Excel Discussion (Misc queries) |