I am having trouble with spaces in cell values, due to which I can't perform calculations with the values. The trim function is not working either. I'm attaching a sample file. Any Guidance will be appreciated.
I am having trouble with spaces in cell values, due to which I can't perform calculations with the values. The trim function is not working either. I'm attaching a sample file. Any Guidance will be appreciated.
Last edited by terry3218; 04-07-2016 at 11:14 AM. Reason: wrote time instead of trim
Which cell(s) have spaces you want to get rid of?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Amount cell (column E). Thanks for the response.
B4 contains ASCII code 160 (which appears as a blank space). If you have a regular keypad keyboard, You can Find/Replace (CNTRL H) Find what: ALT + 160 (on keypad), Replace with: leave blank
See post 4, Replace All
If you do not have a keypad, you can copy it (a blank space) from the spreadsheet and paste it into the FIND/Replace Window
Wow!!! Thanks! Works like a magic. You saved me from hours of manual calculations, thanks again!
Adding to your reputation!
The macro at this website will remove all leading/trailing
and multiple interspersed char 32 space characters.
It will also remove and/or convert char 160 non breaking
spaces into standard char 32 space characters. It will
work on text or numbers and the numbers will be
converted to true numeric numbers.
I use this macro dozens of times every single day!
It's a real time saver.
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Tony Valko, thanks a million for your input. I will surely try this macro.
You're welcome!![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks