I have a column of keywords
I want to add '+' too all words in the column for example
1. Nice here
2. bad here
3. ok man
4. no way
to becomes
1. +Nice +here
2. +bad +here
3. +ok +man
4. +no +way
How ?
I have a column of keywords
I want to add '+' too all words in the column for example
1. Nice here
2. bad here
3. ok man
4. no way
to becomes
1. +Nice +here
2. +bad +here
3. +ok +man
4. +no +way
How ?
Highlight all the cells that you want to change, then do CTRL-H for Find & Replace. Then enter the following in the dialogue box:
Find what: type a single space
Replace with: space followed by +
Click replace all.
Hope this helps.
Pete
Hi maniacs,
Something like:
Formula:Please Login or Register to view this content.
should do. Look at the attached.
Substitute space with plus.xlsx
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Thanks for the rep, Maniacs.
If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks