Adding a pre-fix to each item in a cell

  • Thread starter Thread starter nasadell
  • Start date Start date
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!
 
nasadell said:
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!
Click to expand...

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