LinkBack URL
About LinkBacks
How to get number if text is separated with space on several places:
For example, number can be:
0
1 000
10 000
100 000
1 000 000
10 000 000
(no need over 100 000 000, number can be any.. (like 23 429 332) but always separated as shown
How to get number if text is separated with space on several places:
For example, number can be:
0
1 000
10 000
100 000
1 000 000
10 000 000
(no need over 100 000 000, number can be any.. (like 23 429 332) but always separated as shown
Last edited by zbor; 03-27-2009 at 09:30 AM.
How about?
=SUBSTITUTE(A1," ","")+0
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Doesn't work... Give me an error.. if I remove +0 and leave only =SUBSTITUTE(G555;" ";"") it give me that number (with spaces)
Maybe it is not a real space and a special character...
try:
=Clean(A1)+0
Nope
Can you look here.. different problem... same workbook... (sheet 1, G)
http://www.excelforum.com/excel-gene...ml#post2066157
I don't see anything that looks like what you are describing above.
Try this:
Does that help?
Please Login or Register to view this content.
Looks like CHAR(160) ...
=0+SUBSTITUTE(cell reference,CHAR(160),"")
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Works great
Where did you see that?Originally Posted by DonkeyOte
From the file zbor had uploaded to the other thread he/she referenced in post # 5
Yes, I know.. but I didn't see the cells in column G that had those numbers... maybe I am blind.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks