| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
quotation marks
Hello,
I'm trying to include a quotation mark in a concatenated cell. The numbers in the cells have been converted to text. Cell1=28 Cell2=36 My formula is =(cell1 & " x " & cell2) What is returned is 28 x 36 How can I get the concatenated cell to read 28" x 36". Thanks John |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving Spreadsheet to Unicode extra quotation marks | Excel Discussion (Misc queries) | |||
| Saving Spreadsheet to Unicode extra quotation marks | Excel Discussion (Misc queries) | |||
| Inserting Quotation Marks in all Cells | Excel Discussion (Misc queries) | |||
| How do I concatenate text that actually contains quotation marks? | Excel Worksheet Functions | |||
| Excel Quotation Marks! | Excel Discussion (Misc queries) | |||
Threaded Mode
