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>
ABI117
ABI117A
ABI125
ABI117R...