It's not clear what you're trying to do but...

Then go to AA3, type =AA2&","J3

The correct syntax for that formula would be:

=AA2&","&J3

--
Biff
Microsoft Excel MVP


"Miss_Sue" wrote in message
...
I am trying to extract the e-mail addresses from an Excel file. Below is
the formula I have been trying to use, but apparently my "formula" is
incorrect and I get an error. I only know Excel from using it and I'm in
over my head. Could someone help me please.

AA is the new column to acculumulate all e-mail addresses
J is the column where individual addresses are stored.

To get e-mail addresses:
In a new column (ie. AA1) type new name of field.
Then go to AA2, type in 1st e-mail cell (ie. =J2)
Then go to AA3, type =AA2&","J3
Then copy this formula all the way down.

Also, the above brings in all of the blank cells and appears with only the
"," (i.e. ,,,,). Is there a to omit these from the "formula"?

Thank you for any assistance.

Sue