Nel post
*fomula problems* ha scritto:

I am composing a workbook, and the problem is the amount of input I
need to do, I have 276 rows and will probably have about the same
number of columns, The details I'm entering is as the example
HA002030 then HA002030 in the next row of same column. I finished one
column and thought I would copy the column and paste it in the
subsequent columns and then change the first 2 letters, which would
save me some inputting, I thought I would be able to change the first
two letters by using replace but it won't let me do it, does anyone
have a suggestion how I can change the first two letters in the other
columns. The next column would be HB then HC and so on.
Alan


Hi Alan,

I think this is the fastest way is.

Instead of entering HA002030, type this formula:

="H"&CHAR(64+COLUMN(A$1))&"002030"

Now you can copy down the rows and across the columns.

P.S: You can have till 65536 rows, but no more then 256 columns... Till
Excel 2003...
From Excel 2007 you will have 1048576 rows and 16384 columns...

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy