Thread: Inserting colon as text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
iashorty iashorty is offline
external usenet poster
  
Posts: 41
Default 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?

Reply With QuoteReply With Quote