Hi,
My first post in this forum. Any help is appreciated. Thanks.
What I'm to achieve in ColumnB based on ColumnA: For each ID in ColumnA, create 3 IDs with letters A, R, S appended to the ID.
ColumnA ColumnB
<colgroup><col><col></colgroup><tbody>
</tbody>
What should my formula for ColumnB be?
(I am currently using =INDIRECT("A"&2)&"A" and =INDIRECT("A"&2)&"R" and =INDIRECT("A"&2)&"S" ) But I need a way to copy this formula and paste it for the rest of the column.
Any ideas?
-Em
My first post in this forum. Any help is appreciated. Thanks.
What I'm to achieve in ColumnB based on ColumnA: For each ID in ColumnA, create 3 IDs with letters A, R, S appended to the ID.
ColumnA ColumnB
ABI117 | ABI117A |
ABI125 | ABI117R |
ABI118 | ABI117S |
ABI105 | ABI125A |
ABI100 | ABI125R |
ABI114... | ABI125S... |
<colgroup><col><col></colgroup><tbody>
</tbody>
What should my formula for ColumnB be?
(I am currently using =INDIRECT("A"&2)&"A" and =INDIRECT("A"&2)&"R" and =INDIRECT("A"&2)&"S" ) But I need a way to copy this formula and paste it for the rest of the column.
Any ideas?
-Em