How to output text from several cells into one cell?

**Phokus** · 08-13-2009, 11:27 AM

Say i have the following text formatted cells (say from A1 through A4)

117-U
166-U
179-U
206-6

I want to output the cells so that it outputs like '117-U','166-U','179-U','206-6' in a single cell... how would i go about this?

Thanks in advance!

**DonkeyOte** · 08-13-2009, 11:43 AM

Assuming you have only a few cells ...

="'"&A1&"','"&A2&"','"&A3&"','"&A4&"'"

Else you're looking at UDF's in truth and/or Add-ins like morefunc.xll which offers MCONCAT function.

**Phokus** · 08-13-2009, 12:05 PM

Originally Posted by DonkeyOte

Assuming you have only a few cells ...

="'"&A1&"','"&A2&"','"&A3&"','"&A4&"'"

Else you're looking at UDF's in truth and/or Add-ins like morefunc.xll which offers MCONCAT function.

That worked, thanks!