All 3 columns (A,B,C) together with space between them
D3=A3&” “&B3&” “&C3
All 3 columns (A,B,C) together without space between them
E3=A3&B3&C3
All 3 columns (A,B,C) together with “-” removed in column A and without space between them
F3=TRIM(SUBSTITUTE(A3;”-“;””))&B3&C3
Views: 3
Comments are closed.