Subsitute or Find/Replace words in a phrase

**Crhodes** · 05-24-2013, 06:14 PM

I'm not sure what is the best option for this request. Ideally I'd like to be able to copy & paste a text string into an excel spreadsheet such as the one below that is then referred back to in order to complete three cells (Headline, Desc 1 and Desc 2) based on the copy version (1-4) in the corresponding [client,city,program,type,variation]. I've attached a spreadsheet so you can see how it is set up, any ideas?Excel Help 2.xlsx

Text String

Client City Program Type Variation
G-Client-CA-NB-Geo-Airdrie-English-Tutor-Homework-Best

BEFORE
Copy Headline Desc 1 Desc 2
1 [client] Learning Center [client] [program] [type]s Can Help Your Child. Get Started Now & Save $25!
2 [client] [program] Tutors [program] [variation]? Sylvan Tutors Can Help, Call Us Now & Save $25!
3 [client] in [city] Personal [program] [type]s Can Help Your Child. Get Started Now & Save $25!
4 [client] Learning Center [city] [program] [type] Can Help Your Child. Start Now & Save $25!

AFTER
Copy
1 Client Learning Center Client English Tutors Can Help Your Child. Get Started Now & Save $25!
2 Client English Tutors English Homework? Client Tutors Can Help, Call Us Now & Save $25!
3 Client in Airdrie Personal English Tutors Can Help Your Child. Get Started Now & Save $25!
4 Client Learning Center Airdrie English Tutors Can Help Your Child. Start Now & Save $25!

**Ghozi Alkatiri** · 05-24-2013, 07:07 PM

write in N9
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(N3,"[",""),"]",""),"program",$I9),"city",$H9),"type",$J9),"variation",$K9)

copy right and down

**FDibbins** · 05-24-2013, 08:20 PM

Hi and welcome to the forum

Hopefully Ghozi's suggestion works for you

If not, to make it easier to understand what you want, I would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.