 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008Text to num transfer
My CRM system creates an Excefile with sales statistics. But the figures are in text format with a space insertet after the thousand figure. When i try to use the VALUE formula it does not return a value due to the space in the text (at least that is what I belive). Does anyone have an idea how to work around this problem? Try selecting the range of cells with the space, pressing CTL-H to bring up the replace dialog and change all spaces to nothing (no entry). Bob Flanagan Macro Systems http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel > My CRM system creates an Excefile with sales statistics. > But the figures are in text format with a space insertet after the [quoted text clipped - 4 lines] > > Does anyone have an idea how to work around this problem? Sorry, I tried that, Excel returns "cannot find a match" and nothing change.//Christer > Try selecting the range of cells with the space, pressing CTL-H to bring up > the replace dialog and change all spaces to nothing (no entry). [quoted text clipped - 12 lines] > > > > Does anyone have an idea how to work around this problem? >Sorry, I tried that, Excel returns "cannot find a match" and nothing >change.//Christer Most likely that is not a <space> but rather a <nbsp>. In the Find What: line of the Find/Replace dialog box, enter the following: While holding down the <alt> key, enter 0160 on the numeric keypad (and NOT on the numbers above the keyboard). Then release the <alt> key. Leave the Replace With: line empty (with no <space>) --ron > >Sorry, I tried that, Excel returns "cannot find a match" and nothing > >change.//Christer [quoted text clipped - 10 lines] > Leave the Replace With: line empty (with no <space>) > --ron Thank you Ron. I took a shortcut and copy/paste whatever the "space" was into Find/Replace dialog box. And like a miracle they all disappear and the text was transferred into figures. It saves hours for me! Thank you, Christer >Thank you Ron. > [quoted text clipped - 5 lines] > >Christer Good to hear. Thanks for the feedback. --ron
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.