Thursday, 15 August 2013

Is there an equivalent of printf or String.Format in Excel -


I spend a lot of time in spreadsheets that work on the form: 

  = "Some text" "& amp; A1 and A." ', and text:' '& amp; A2 and "etc."   
 This will be faster to use a printf or String.Format string  
  = String.Format ("some Lesson '{0}', more text: '{1}' ", A1, A2)   
 Is there something like this built in Excel, or without writing a macro I Can I call in CLR?  
 
 
 No, but you can make a naive person by adding the following to only one VBA module    
 ...  
  = printf ("some text '{0} ', More text:' {1} '", A1, A2)    

 








Posted by



at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)