Adding a pre-fix to each item in a cell

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!
 
G

Glenn

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!

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top