On Wednesday, October 17, 2012 1:33:44 PM UTC-5, JAlvarez wrote:
Hi,

In excel I have a list of invoice numbers, one on each cells (multiple

rows)



43333,

43332,

12323,

78922,



I need a formula that will put all those in a single line/cell and with

a single quote in between, so like this:



'43333','43332','12323','78922',



Any help would be appreciated. Thanks!









--

JAlvarez

You don't say how many rows to put in a single cell (or different columns on the same row)