| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert new colums after each one existing column
Hi All,
I have a spreadsheet spanning 500 rows for which I would like to add a number of columns after each exisiting column. Say the current sheet looks like A,B,C; I would want it to look like A,a1,a2,a3,B,b1,b2,b3,C,c1,c2,c3, Where the lowecase colums followed by a number are the colums that are to be inserted. Since the sheet comprises of 500 columns, I suspect there is a faster way than doing this manually, I just don't know how to. Could you help me out? Best regards, Ralph |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I insert a colon into a column of existing numbers | Excel Discussion (Misc queries) | |||
| match first and last name and insert column into existing sheet | Excel Worksheet Functions | |||
| How do I insert sub-columns within an existing column? | Excel Discussion (Misc queries) | |||
| Insert 5 rows between existing values in a single column 1 | Excel Worksheet Functions | |||
| How do I insert hypens in existing column representing social sec. | Excel Discussion (Misc queries) | |||
Threaded Mode
