**Question description:**

*This user has given permission to use the problem statement for this
blog.*

I need to take a column of keywords and have a formula turn them into 3 variations for each keyword. Example: Keyword Phrase A turns into 3 different variations that are:
"Keyword Phrase A"
+Keyword Phrase A+
[Keyword Phrase A]

Solved by G. Y. in 60 mins

This is the chat thread from the real Excelchat help session. It contains no private user
information.

Excelchat Expert
24/08/2018 - 05:06

Hi welcome!

User
24/08/2018 - 05:06

hi

User
24/08/2018 - 05:07

should i paste in an example of what I need the finished product to look like?

Excelchat Expert
24/08/2018 - 05:08

Yes, or upload a sheet

User
24/08/2018 - 05:08

wait, that's not right

User
24/08/2018 - 05:09

it didn't paste in right

User
24/08/2018 - 05:09

i'll upload a sheet

User
24/08/2018 - 05:09

just a sec

Excelchat Expert
24/08/2018 - 05:09

ok

User
24/08/2018 - 05:12

take a look. let me know if that makes sense

[Uploaded an Excel file]

Excelchat Expert
24/08/2018 - 05:13

I have the sheet and data in columns

Excelchat Expert
24/08/2018 - 05:13

Not sure I get what is needed?

User
24/08/2018 - 05:14

i have a list of keywords (the "what I have") column

Excelchat Expert
24/08/2018 - 05:14

ok

User
24/08/2018 - 05:15

and I need a formula or set of formulas that can take those keywords and put them into new columns. with the addition of the " " and + + and [ ] added to them

User
24/08/2018 - 05:16

i just need a quick way to do this, i have hundreds of keywords that need to be formatted like that before i can upload them to google adwords

Excelchat Expert
24/08/2018 - 05:16

ok, so replace column B with formula that matches current content

User
24/08/2018 - 05:16

yes

User
24/08/2018 - 05:17

and also column D. that just needs a formula that pastes the same keyword in place. no formatting changes

User
24/08/2018 - 05:17

like it's currently being shown in the example

User
24/08/2018 - 05:17

if that makes sense

Excelchat Expert
24/08/2018 - 05:18

You mean column E?

User
24/08/2018 - 05:18

No, column D. there's nothing in column E

Excelchat Expert
24/08/2018 - 05:19

Sorry, i started by inserting a column

User
24/08/2018 - 05:19

ok. np. that's fine

Excelchat Expert
24/08/2018 - 05:19

That is column D in the view screen

User
24/08/2018 - 05:20

yes. that's right

User
24/08/2018 - 05:24

if you're still not sure what i need

User
24/08/2018 - 05:24

https://www.screencast.com/t/CIGJr7y3zzow

User
24/08/2018 - 05:24

just recorded that video

Excelchat Expert
24/08/2018 - 05:25

Working it- EXCEL does not like inserting ""

User
24/08/2018 - 05:25

ah, ok

Excelchat Expert
24/08/2018 - 05:25

since part of normal text operatins

User
24/08/2018 - 05:37

still working on it?

Excelchat Expert
24/08/2018 - 05:37

Yes, each of these requires a separate formula

Excelchat Expert
24/08/2018 - 05:38

and will be examples

Excelchat Expert
24/08/2018 - 05:38

a full set will require much more analysis and code

Excelchat Expert
24/08/2018 - 05:39

since text manipulation depends on text length and position of characters

User
24/08/2018 - 05:39

ok, but you'll give me examples of the formulas to use for each?

Excelchat Expert
24/08/2018 - 05:40

Yes

User
24/08/2018 - 05:40

ok cool

User
24/08/2018 - 05:50

i have to leave my computer soon. how quickly will you have those formulas ready?

Excelchat Expert
24/08/2018 - 05:50

10 mins.

Excelchat Expert
24/08/2018 - 05:50

on last now, just need check then post back

User
24/08/2018 - 05:50

ok

Excelchat Expert
24/08/2018 - 05:59

[Uploaded an Excel file]

Excelchat Expert
24/08/2018 - 05:59

Ok, please review

User
24/08/2018 - 06:02

it looks like there is an extra " on the right side of the keywords

Excelchat Expert
24/08/2018 - 06:02

[Uploaded an Excel file]

Excelchat Expert
24/08/2018 - 06:02

Yes, saw that, this is the fix

User
24/08/2018 - 06:02

there should be one " on either side. but there's one on the left and two on the right

Excelchat Expert
24/08/2018 - 06:03

forgot one

[Uploaded an Excel file]

Excelchat Expert
24/08/2018 - 06:03

good now

Excelchat Expert
24/08/2018 - 06:04

It is the + married in Ohio that is a tough one

User
24/08/2018 - 06:04

ok great. this looks good. thanks!!

Excelchat Expert
24/08/2018 - 06:05

Ok, thanks, for stopping by

Excelchat Expert
24/08/2018 - 06:05

Please come back if you needany EXCEL help in the future.

Excelchat Expert
24/08/2018 - 06:05

Bye!

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user
information.*