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! |
Adding a pre-fix to each item in a cell
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-") |
All times are GMT +1. The time now is 05:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com