It would if you used R1C1 reference style instead of letters.

NM wrote:
This means it has to be done manually, excel doesn't tell you the column name
equivalent to the number.

"Bob I" wrote:


There are 26 letters in the alphabet. 26 would get you to AP, so add one.

NM wrote:


Thanks David,it worked.

But I want to how do we know that from column O to AO it is 27 columns? Do
we count all the way from O to AO to see if that equals 27 or is there a
easier way to know that?

Thanks!

"David Biddulph" wrote:



Select Column O
Shift and select Column AO
Insert/ Columns
--
David Biddulph

"NM" wrote in message
...


Hi,

I have coulmns A through CJ and I want to add 27 coulmns before column O.
What is the easiest way to do it?

Thanks for your help.
Nee