Excel

Tuesday, March 21, 2017

Convert a number to text e.g. for vlookup

e.g. if your number is in A2, then:

=A2&""
Posted by NextLevel at 7:57 PM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

NextLevel
View my complete profile

Blog Archive

  • ▼  2017 (41)
    • ►  October (1)
    • ►  September (1)
    • ►  June (18)
    • ►  May (16)
    • ▼  March (5)
      • Finding last row, last column, and last used cell
      • Resources
      • IFNA
      • Convert a number to text e.g. for vlookup
      • Remove autofilter if on
  • ►  2016 (8)
    • ►  December (1)
    • ►  November (3)
    • ►  October (4)
Simple theme. Powered by Blogger.