| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Exporting to .txt converts single quotes to double quotes | Excel Programming | |||
| Save delimited format, specify delimiter, remove quotes from text | Excel Discussion (Misc queries) | |||
| How to get Excel CSV format in to write text cells in quotes? | Excel Discussion (Misc queries) | |||
| my code is adding single quotes | Excel Programming | |||
| Single quotes in named range | Excel Worksheet Functions | |||
Threaded Mode
