I need to combine a fixed text statement to a variable text state.

E

Eddie Crocker

I am importing text into cells in a column. I want to put a formula into
another colum that will append a fixed text statement to each one of the
variable statement in the first collumn.

Example:
Col #1 Col #2
ABC Set - ABC
CDE Set - CDE
EFG Set - EFG
 
E

Ed

The formula works like a champ. Thank you. You just saved me as many as
several days of manual entry.
 
Top