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
[TABLE="width: 271"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]ABI117[/TD]
[TD]ABI117A[/TD]
[/TR]
[TR]
[TD]ABI125[/TD]
[TD]ABI117R[/TD]
[/TR]
[TR]
[TD]ABI118[/TD]
[TD]ABI117S[/TD]
[/TR]
[TR]
[TD]ABI105[/TD]
[TD]ABI125A[/TD]
[/TR]
[TR]
[TD]ABI100[/TD]
[TD]ABI125R[/TD]
[/TR]
[TR]
[TD]ABI114...[/TD]
[TD]ABI125S...
[/TD]
[/TR]
</tbody>[/TABLE]
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
[TABLE="width: 271"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]ABI117[/TD]
[TD]ABI117A[/TD]
[/TR]
[TR]
[TD]ABI125[/TD]
[TD]ABI117R[/TD]
[/TR]
[TR]
[TD]ABI118[/TD]
[TD]ABI117S[/TD]
[/TR]
[TR]
[TD]ABI105[/TD]
[TD]ABI125A[/TD]
[/TR]
[TR]
[TD]ABI100[/TD]
[TD]ABI125R[/TD]
[/TR]
[TR]
[TD]ABI114...[/TD]
[TD]ABI125S...
[/TD]
[/TR]
</tbody>[/TABLE]
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