Hi,

I was wondering if anyone could help me with something in EXCEL. I don't really know what I am doing in it. I have a spread sheet with lists of account numbers and notes next to them. I want to have excel combine all of the rows of notes with the same account number.

How is it done?

So, you have multiple rows with the same account number?  Right?  For those rows, are the notes the same, or do they vary?Thanks for the reply. No, the notes are different. So we NEED to get all of the notes COMBINED, in one cell with the corresponding account number.

Thanks!

MacHow many records/rows are in this Excel file?  I don't know of a way to automate this, and doing it MANUALLY will be a tedious procedure if you have a large number of records.

To manually do this, you could copy the notes for each account to Notepad.  Then when you have all the notes for a particular account consolidated in Notepad, copy them back to Excel.  Ya, I have goten to that point. I have almost 600 accounts with about 20,000 rows. Yuck. Thanks anyway!I presume you're sorting those records to get all the records for a particular account listed together.  I will mention the Concatenate function, in case that might help.  If you're not familiar with it, take a look in Excel's Help.  You can also combine text from different cells by using the & symbol.  For example: A1 contains Good and B1 contains bye.  To make C1 display Goodbye, TYPE =A1&B1 in C1.