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

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

Cheers Franz for replying, I have filled out the columns but every column is
the same, made a mistake in my message it should have readas follows
HA002020
HA002030
HA002040
HA002050
HA003020
HA003030
HA003040
HA003050
And so on, then the next column would be HB then HC then HD and so on.

Alan

"Franz Verga" wrote:

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

If I well understand you will have till HA009050 and after this HA202020,
HA202020, and so on... Till HA909050. I'm right? Or you'll have till
HA005050 and then HA202020, HA202020, and so on till HA505050?

Let me know. It's important to avoid me work...


Nel post
*fomula problems* ha scritto:

Cheers Franz for replying, I have filled out the columns but every
column is the same, made a mistake in my message it should have
readas follows HA002020
HA002030
HA002040
HA002050
HA003020
HA003030
HA003040
HA003050
And so on, then the next column would be HB then HC then HD and so on.

Alan

"Franz Verga" wrote:

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

--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

HA002020-HA002050
HA003020-HA003050
HA004020-HA004050
up to.
HA050020-HA0500-50
then its.
HA050120-HA050150
HA050220-HA050250
up to.
HA052020-HA052050
then stops.
hope this makes sense.
Alan
"Franz Verga" wrote:

If I well understand you will have till HA009050 and after this HA202020,
HA202020, and so on... Till HA909050. I'm right? Or you'll have till
HA005050 and then HA202020, HA202020, and so on till HA505050?

Let me know. It's important to avoid me work...


Nel post
*fomula problems* ha scritto:

Cheers Franz for replying, I have filled out the columns but every
column is the same, made a mistake in my message it should have
readas follows HA002020
HA002030
HA002040
HA002050
HA003020
HA003030
HA003040
HA003050
And so on, then the next column would be HB then HC then HD and so on.

Alan

"Franz Verga" wrote:

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

--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy