Saturday, 23 January 2016

The Length of a Number stored as String in Excel

It's always LEN(X)-1, where X is the cell reference. We need to subtract 1 for the preceding apostrophe!
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)