View Single Post
  #1   Report Post  
JAlvarez JAlvarez is offline
Junior Member
 
Posts: 2
Default 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!