Hello Excel Gurus,
This is my first post to any forum ever so forgive me if have made any mistake.
I have searched for forum but could not locate something that matches.
I have column with cells having values varies in QTY and separated by comma.
I like to add suffix to each value in cell that separated by comma.
example below with what output should look like.
column a
A,B,C
A,B
H,U,L,P
K1
R1
X12,X13,X18
G1,G7,G9,G14,G19
I like to add suffix"_BD" to each value in cell SO
Output should be like below
column b
A_BD,B_BD,C_BD
A_BD,B_BD
H_BD,U_BD,L_BD,P_BD
K1_BD
R1_BD
X12_BD,X13_BD,X18_BD
G1_BD,G7_BD,G9_BD,G14_BD,G19_BD
Regards,
Chingoni
This is my first post to any forum ever so forgive me if have made any mistake.
I have searched for forum but could not locate something that matches.
I have column with cells having values varies in QTY and separated by comma.
I like to add suffix to each value in cell that separated by comma.
example below with what output should look like.
column a
A,B,C
A,B
H,U,L,P
K1
R1
X12,X13,X18
G1,G7,G9,G14,G19
I like to add suffix"_BD" to each value in cell SO
Output should be like below
column b
A_BD,B_BD,C_BD
A_BD,B_BD
H_BD,U_BD,L_BD,P_BD
K1_BD
R1_BD
X12_BD,X13_BD,X18_BD
G1_BD,G7_BD,G9_BD,G14_BD,G19_BD
Regards,
Chingoni