Excel 2010/2007 and older versions can examine and change text for you. Many people have product codes importing into Excel and then prepare reports but many times Excel does not work with the numbers. The first function to use is LEN - this tells you the length of the string ( as there may be blanks also). More training at http://www.actionebiz.com/exceltraining.htm
Bert Twomey
MS Excel Training
Toronto, Mississauga,
No comments:
Post a Comment