User Tools

Site Tools


handy_excel_tips_and_tricks

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
handy_excel_tips_and_tricks [2012/09/04 13:19]
cliff
handy_excel_tips_and_tricks [2012/09/04 13:29] (current)
cliff
Line 206: Line 206:
  
 For bar codes other than 12 digits, change the number of 0's in the quotations to return the desired string length. For bar codes other than 12 digits, change the number of 0's in the quotations to return the desired string length.
 +
  
  
  
 ==== Sample way to replace INSTR VBA functionality ==== ==== Sample way to replace INSTR VBA functionality ====
-See article below copied from web at http://​www.mrexcel.com/​forum/​excel-questions/​76765-equivalent-instr-instrrev-excel.html. Thanks to the MRExcel website as well pnhughes the user who answered the question I was able to find by searching on Google.+See article below copied from web at http://​www.mrexcel.com/​forum/​excel-questions/​76765-equivalent-instr-instrrev-excel.html. Thanks to the MRExcel website as well pnhughes the user who answered the question I was able to find by searching on Google. Maybe with this link / article here, I will remember the "​Find"​ function instead of having to Google it :) .
  
 <​code>​ <​code>​
handy_excel_tips_and_tricks.txt ยท Last modified: 2012/09/04 13:29 by cliff