Posts by anncognito

  • Add Comma To Each Cell In Column

    Re: Add Comma To Each Cell In Column


    Oh.My.God. It works just like you said!!!


    Thank You, thank you, THANK YOU!!!!


    I've been unwell and then the weekend came, and this is my first chance to try your suggestion and get back to you about it.


    I've been pulling the copy into Microsoft Word and running a macro and then playing with "convert text to table" and "convert table to text" and this method worked according t the whims of the computer, or sunspot activity, or ????


    This looks like a much more reliable and time-saving (not to mention neck-muscle-saving) method.


    StephenR, there is a wonderful glow in my heart for you. I'll do what I can about the rest of mankind. :)


    Susan

  • Add Comma To Each Cell In Column

    Re: Add Comma To Each Cell In Column


    When I try to copy B1 and paste it into B2, the box around B2 gets blue and has a dashed border.


    If I can get it to copy, do I go down to the end (Bx) and hold the shift key down and click to fill all the cells? Do I have to copy the cells one at a time?


    I have so little understanding of how Excel works == this is the only job I am tasked to do that involves it at all, and I really appreciate everyone's suggestions. I usually use Quark and Creative Suite, this program makes me feel so stupid!

  • Add Comma To Each Cell In Column

    Re: Add Comma To Each Cell In Column


    I think I understand... when I get back to work I will try these suggestions.


    Nice use of Stewie, Mr Administrator... He's my favorite little tyrant!


    (I would add a smilie, but they're not showing up)
    Susan[hr]*[/hr] Auto Merged Post Until 24 Hrs Passes;[dl]*[/dl]When I copy the =A1&"," and paste it into subsequent cells in the new column, I get the first name over and over in the new column. I need to take a column that has, say, these names:


    Abadie
    Ackley
    Aguilera
    Ainsworth


    etc, and add a comma to each name, resulting in a column that looks like:


    Abadie,
    Ackley,
    Aguilera,
    Ainsworth,


    Is there a fast way to do this? I have 366 names to put a comma behind.
    Right now I have the startings of a column that looks like


    Abadie,
    Abadie,
    Abadie,
    Abadie,


    I can see that I can get what I want if I change the number in the cell to correspond with the row that I'm on but it seems like it would be easier to just type 366 commas.


    What am I not getting? What I don't know about Excel would fill a large book... a book about Excel

  • Add Comma To Each Cell In Column

    I am an Excel Novice. I don't know very much at all about how it works, what formulas are or any of its intracacies. My job requires me to take information from an Excel file that is emailed to me.


    I need to know in the simplest terms how to take the first column (which is last names) and add a comma to the end of each name (one in each cell) all the way down that column, before I copy and paste them, so they will read "last name comma space first name".


    If someone can answer this for me and I can make it actually work, it will give me a wonderful glow in my heart towards mankind.


    Thank you!