I have a column that contains cells that either have: nothing (blank), one
word, or multiple words separated by commas.

I need to add a pre-fix to each word in each cell. The prefix is "ARESI-US-"

For instance:
Cell A1:
AVION01, PROP01, PRESS03, PRESS04, PRESS05

I need A1 to turn into:
ARESI-US-AVION01, ARESI-US-PROP01, ARESI-US-PRESS03, ARESI-US-PRESS04,
ARESI-US-PRESS05

Thank you!

nasadell wrote:
I have a column that contains cells that either have: nothing (blank), one
word, or multiple words separated by commas.

I need to add a pre-fix to each word in each cell. The prefix is "ARESI-US-"

For instance:
Cell A1:
AVION01, PROP01, PRESS03, PRESS04, PRESS05

I need A1 to turn into:
ARESI-US-AVION01, ARESI-US-PROP01, ARESI-US-PRESS03, ARESI-US-PRESS04,
ARESI-US-PRESS05

Thank you!

="ARESI-US-"&SUBSTITUTE(A1," "," ARESI-US-")