Full Version: =Right(cell,2) excluding spaces
UtterAccess Discussion Forums > Microsoft® Office > Microsoft Excel
taosd
I have a cell that has a bunch of characters in it, and I want to have it return the last 6 digits in the string. The problem is that Sometimes the cell will have a space at the end and sometimes it won't. So I need it to return only digits and exclude the space, how can I do this?
NateO
Hello, see the subject.

Bon chance.
taosd
thanks!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.