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.
