Thread: Preprend Text Where Cell Not Empty
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Fan924 Fan924 is offline
external usenet poster
  
Posts: 238
Default Preprend Text Where Cell Not Empty
Somethig like ?

If ApptNo = "" then
Else
ApptNo = "# " & ApptNo
End If
Reply With QuoteReply With Quote