| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
concatenating text with address reference
Thank you NOPIK - I understand you to mean that not just an extra set of
quotes, but two extra sets around the text. Anyway it works - thank you again. "NOPIK" wrote: Buy youself a BASIC or programming manual (seriously, you will discover a lots of "tricks"). For example, if you need string quotation character inside the string - just double it: """" - will result a " in string. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert ADDRESS() text result to cell reference | Excel Worksheet Functions | |||
| Hyperlink Address and SubAddress not concatenating correctly | Excel Discussion (Misc queries) | |||
| Concatenating a cell address | Excel Worksheet Functions | |||
| Construct address as a reference not "text" | Excel Worksheet Functions | |||
| How can I convert text to reference ? Ex: ISNUMBER(ADDRESS(6;10;2. | Excel Discussion (Misc queries) | |||
Hybrid Mode
