Excel - COLUMN Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc