|
Sheet layout
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 |
Sheet layout
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 |
Sheet layout
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 |
Sheet layout
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 |
Sheet layout
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 |
| All times are GMT +1. The time now is 07:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com