| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting colon as text
I am using the following
ActiveCell.FormulaR1C1 = "=CONCATENATE(PriorYear&" - "&PriorMonth&": "&VLOOKUP(RC[-26],'Prior Month'!R9C1:R1009C12,12,FALSE),CHAR(10),'Prior Month'!RC[-17])" to pull in prior month commentary and adding a date stamp with a COLON between the two. The above should look like: 2007-08: This situation... The colon in not being accepted. What is the string to insert a colon as text in this formula? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to change colon to semi-colon in CP/List Seprator | Excel Discussion (Misc queries) | |||
| inserting colon into a value at a specific interval | Excel Programming | |||
| Macro - Inserting text to a cell already containg text | Excel Discussion (Misc queries) | |||
| inserting colon | Excel Programming | |||
| Insert colon in text in cell | Excel Discussion (Misc queries) | |||
Threaded Mode
