Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-30-2012, 07:43 AM
kkerr kkerr is offline Right formula putting in spaces Windows XP Right formula putting in spaces Office 2007
Novice
Right formula putting in spaces
 
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
  #2  
Old 08-30-2012, 08:05 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Right formula putting in spaces Windows 7 32bit Right formula putting in spaces 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)
Reply With Quote
  #3  
Old 08-30-2012, 10:15 AM
kkerr kkerr is offline Right formula putting in spaces Windows XP Right formula putting in spaces Office 2007
Novice
Right formula putting in spaces
 
Join Date: Aug 2012
Posts: 6
kkerr is on a distinguished road
Default

What is happening is I will use the formula you provided, but when I copy and paste the values into the column I need it in it is putting the spaces in then
Reply With Quote
  #4  
Old 08-30-2012, 11:33 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Right formula putting in spaces Windows 7 32bit Right formula putting in spaces Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Sounds strange - can you attach an example workbook which demonstrates the problem so I can investigate it?
Reply With Quote
  #5  
Old 08-30-2012, 12:07 PM
kkerr kkerr is offline Right formula putting in spaces Windows XP Right formula putting in spaces Office 2007
Novice
Right formula putting in spaces
 
Join Date: Aug 2012
Posts: 6
kkerr is on a distinguished road
Default

Please see attached. I used your trim formula starting in A263. The 745s I did manually. If you manually take the space out in front of it, the Division will show up otherwise it won't.
Attached Files
File Type: zip Division Update+formulas(1).zip (1.35 MB, 8 views)
Reply With Quote
  #6  
Old 08-30-2012, 12:16 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Right formula putting in spaces Windows 7 64bit Right formula putting in spaces Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

No file attached
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #7  
Old 08-30-2012, 12:33 PM
kkerr kkerr is offline Right formula putting in spaces Windows XP Right formula putting in spaces Office 2007
Novice
Right formula putting in spaces
 
Join Date: Aug 2012
Posts: 6
kkerr is on a distinguished road
Default

Sorry about that. Can you see if it is uploaded now?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Right formula putting in spaces putting in horizontal lines BigDan Word 1 03-20-2012 12:21 AM
Right formula putting in spaces Putting text to Excel Leandro Office 2 03-01-2012 11:51 PM
Right formula putting in spaces Putting italics back into a document lordofscones Word 8 12-06-2011 07:54 PM
Right formula putting in spaces Putting an image with hyperlink to certain slides spiffmonkey1 PowerPoint 1 07-17-2011 03:58 PM
Putting periods/dots around the letter A ph3iron Word 0 03-27-2010 06:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:50 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft