Thread: [Solved] Right formula putting in spaces
View Single Post
 
Old 08-30-2012, 08:05 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default
TRIM() will remove the spaces.

=right(trim(a1),3)
__________________
Colin

RAD Excel Blog
Reply With Quote