View Single Post
 
Old 08-30-2012, 07:43 AM
kkerr kkerr is offline Windows XP Office 2007
Novice
 
Join Date: Aug 2012
Posts: 6
kkerr is on a distinguished road
Question Right formula putting in spaces

When I use the formula =right(a1,3) it is returning a number that has an invisible space in front of the 3 digits...is there any way around this without going into the cell to delete the space?
Reply With Quote