+ Reply to Thread
Results 1 to 4 of 4

add + to all words

  1. #1
    Forum Contributor
    Join Date
    09-20-2018
    Location
    Jakarta
    MS-Off Ver
    google
    Posts
    102

    add + to all words

    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 ?

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,726

    Re: add + to all words

    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

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: add + to all words

    Hi maniacs,

    Something like:
    Formula: copy to clipboard
    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.

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,726

    Re: add + to all words

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 07-12-2019, 04:44 PM
  2. Replies: 1
    Last Post: 05-18-2018, 06:38 AM
  3. Replies: 1
    Last Post: 06-15-2015, 03:25 PM
  4. Replies: 15
    Last Post: 10-12-2014, 08:53 AM
  5. Replies: 5
    Last Post: 09-02-2014, 03:49 PM
  6. Replies: 3
    Last Post: 11-28-2012, 04:00 AM
  7. Replies: 1
    Last Post: 04-04-2012, 07:15 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1