#1
|
|||
|
|||
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?
|
#2
|
||||
|
||||
TRIM() will remove the spaces.
=right(trim(a1),3) |
#3
|
|||
|
|||
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
|
#4
|
||||
|
||||
Sounds strange - can you attach an example workbook which demonstrates the problem so I can investigate it?
|
#5
|
|||
|
|||
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.
|
#6
|
||||
|
||||
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 |
#7
|
|||
|
|||
Sorry about that. Can you see if it is uploaded now?
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
putting in horizontal lines | BigDan | Word | 1 | 03-20-2012 12:21 AM |
Putting text to Excel | Leandro | Office | 2 | 03-01-2012 11:51 PM |
Putting italics back into a document | lordofscones | Word | 8 | 12-06-2011 07:54 PM |
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 |