View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
nasadell nasadell is offline
external usenet poster
 
Posts: 1
Default Adding a pre-fix to each item in a cell

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!