How to copy an entire column into one cell?

**Mumps** · 06-15-2011, 01:41 PM

Hey there. I have a rather weird problem. I need to copy an entire row of data into one cell. Let me give you an example of what my output needs to be.

COLUMN A
AAAAA
AAAAB
AAAAC
AAAAD
AAAAE

The output I need in my one cell is:
AAAAA,AAAAB,AAAAC,AAAAD,AAAAE,

Is there an easy way to do this? I know it's strange, but unfortunately this is the output I need...

Thanks a ton!

**shg** · 06-15-2011, 02:08 PM

One way:

Please Login or Register  to view this content.

**strokescribe** · 06-19-2011, 09:47 AM

How about VBA?

Please Login or Register  to view this content.

**shg** · 06-19-2011, 12:41 PM

strokescribe,

Please take a few minutes to read the forum rules, and then edit your post to add CODE tags.

Thanks.

**martindwilson** · 06-19-2011, 01:12 PM

word works here as well ,
copy paste special as unformatted text into word(paste special is in the edit menu of word)
find replace ^p with , paste back into excel