Results 1 to 3 of 3
  1. #1
    ABW Ambassador
    Join Date
    January 18th, 2005
    Location
    Nunya, Business
    Posts
    23,684
    I am spreadsheet illiterate.

    I have a list of keywords in 1 column and i want to add a " to the end of them all at once. Is there any way to do that. Thanks

    I work in lounge pants

  2. #2
    ABW Ambassador
    Join Date
    January 18th, 2005
    Posts
    804
    Hi Trust,

    If your list of words is in column A, place " in cell C1.

    Then in cell B1, type in =CONCATENATE(A1,$C$1)

    Copy this down to the bottom of your list.

    Copy column b, then edit and paste special only the values into column A.

    Delete Column B and cell C1.

  3. #3
    ABW Ambassador
    Join Date
    January 18th, 2005
    Location
    Nunya, Business
    Posts
    23,684
    Thanks wyvern, am trying it out now.

    I work in lounge pants

  4. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. OPM -> Program Spreadsheet?
    By isellstuff in forum Midnight Cafe'
    Replies: 2
    Last Post: May 1st, 2014, 10:08 PM
  2. Microsoft's Search Utility Question
    By Billy Kay in forum Midnight Cafe'
    Replies: 0
    Last Post: April 30th, 2007, 12:44 PM

Posting Permissions

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