N
nasadell
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!
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!