Hello, is there an easy way to append data to the end of a cell in 2007?
For instance, I need to add a text string to a list of names in a worksheet, such as Happy Holidays. This text should be added to an existing list of names.
Help!
Hello, is there an easy way to append data to the end of a cell in 2007?
For instance, I need to add a text string to a list of names in a worksheet, such as Happy Holidays. This text should be added to an existing list of names.
Help!
If your list of names is in column A, then in B, you'd have to have the formula in B1dragged down as far as you need it.Please Login or Register to view this content.
You can then copy and Paste Values back over the original cells and delete or clear column B. Does that work for you?There's no direct way to add the value to the original cells without using VBA.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks