formula to format text with single quotes
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!
|