+ Reply to Thread
Results 1 to 5 of 5

Adding something quickly to all cells in a column

Hybrid View

  1. #1
    Registered User
    Join Date
    04-30-2015
    Location
    NY
    MS-Off Ver
    2013
    Posts
    8

    Adding something quickly to all cells in a column

    This might be a dumb question and I apologize if it is.

    I'm looking to add a comma after every name in an entire column.

    So column A has 500 rows of names. Right now they read:
    Smith. John

    I need them to read:
    Smith. John,

    Is there a way to add that without having to do each one individually?

    Thanks in advance.

  2. #2
    Valued Forum Contributor
    Join Date
    04-12-2012
    Location
    India
    MS-Off Ver
    Excel 2007, 2010, 2013, 2016, 2019, Office 365, Google Spreadhsheet
    Posts
    640

    Re: Adding something quickly to all cells in a column

    in B1 = "=CONCATENATE(A1,",") and drag it to down



    Hope this will help you.


    Cheers!!!

    Anil Dhawan
    Thanks,
    Anil Dhawan


    Click *Add Reputation to say "Thanks" and don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved) if you are satisfied.

    Don't stop when you are tired. STOP when you are done!

  3. #3
    Registered User
    Join Date
    04-02-2015
    Location
    MO
    MS-Off Ver
    2010
    Posts
    9

    Re: Adding something quickly to all cells in a column

    You can also try:

    =A1&","

    Saves a few keystrokes.

    Then you can double-click the little black box in the bottom right of the cell that contains the formula and it will fill down the formula rather than having to drag it.

  4. #4
    Registered User
    Join Date
    04-30-2015
    Location
    NY
    MS-Off Ver
    2013
    Posts
    8

    Re: Adding something quickly to all cells in a column

    Perfect! Thank you both!

  5. #5
    Valued Forum Contributor
    Join Date
    04-12-2012
    Location
    India
    MS-Off Ver
    Excel 2007, 2010, 2013, 2016, 2019, Office 365, Google Spreadhsheet
    Posts
    640

    Re: Adding something quickly to all cells in a column

    Glad it worked....


    Can you please take few seconds and mark this thread as SOLVED and say thanks those who helped you by adding *Add Reputation.


    Cheers!!!

    Anil Dhawan

+ 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. [SOLVED] Merging cells to quickly add information to entire column
    By Erik Thomas in forum Excel General
    Replies: 2
    Last Post: 11-13-2012, 02:34 PM
  2. Replies: 2
    Last Post: 09-02-2011, 03:52 PM
  3. Adding a unique hyperlinks to a column quickly
    By nmss18 in forum Excel General
    Replies: 10
    Last Post: 06-13-2011, 04:15 PM
  4. Adding small units of time and entering them quickly
    By ckdkvk in forum Excel General
    Replies: 1
    Last Post: 01-04-2006, 04:20 AM
  5. [SOLVED] How do I quickly fill a formula result into a column of cells?
    By ckirch in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-12-2005, 12:05 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