+ Reply to Thread
Results 1 to 5 of 5

How to add common word in a filled column ?

Hybrid View

alihayat01 How to add common word in a... 09-18-2013, 02:54 AM
FDibbins Re: How to add common word in... 09-18-2013, 02:56 AM
Fotis1991 Re: How to add common word in... 09-18-2013, 02:59 AM
alihayat01 Re: How to add common word in... 09-18-2013, 03:17 AM
Fotis1991 Re: How to add common word in... 09-18-2013, 03:20 AM
  1. #1
    Registered User
    Join Date
    09-18-2013
    Location
    Pakistan
    MS-Off Ver
    Excel 2013
    Posts
    2

    Question How to add common word in a filled column ?

    I have a column in excel sheet of more than 1000 different names. I want to add S/o with each name how can I do that ?

    -Ali Hayat

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: How to add common word in a filled column ?

    Hi and welcome to the forum

    a quick way to do this is to add a helper column, and then, assuming your data is in A2 downwards, use this...
    ="S/o"&A2 (you didnt specify where you wanted it added, so move it to where you need it)

    When you have copied that down, then copy/paste values over the original data, and then delete the helper column
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: How to add common word in a filled column ?

    An easy way could be this.

    Add a new column. Lets's sat that column with names is column A, starting in A2.

    In the new column in row 2 put this and copy down.

    =A2&" "&"s/o"

    Hide column A if you like.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  4. #4
    Registered User
    Join Date
    09-18-2013
    Location
    Pakistan
    MS-Off Ver
    Excel 2013
    Posts
    2

    Re: How to add common word in a filled column ?

    Thanks A lot Both of U guys !!
    It helped me and saved my time !

    Thanks
    Ali Hayat

  5. #5
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: How to add common word in a filled column ?

    You are welcome and thanks for the feed back.

    As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thank you.

    Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

+ 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. Need help with sorting a column by most common to least common
    By mikenmike0001 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-06-2011, 04:28 PM
  2. Editing code to show common four-word combinations in a column
    By Glayva in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-07-2011, 09:06 AM
  3. Word's Textbox filled from Excel
    By stephaneg in forum Excel General
    Replies: 0
    Last Post: 10-08-2010, 04:53 AM
  4. Formula for returning most common "word" in a row or column
    By Moshsoft in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-13-2009, 06:56 AM
  5. Ignoring common word
    By eijoah in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-07-2007, 01:43 AM

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