Text to num transfer

  • Thread starter Thread starter Christer
  • Start date Start date
C

Christer

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
 
Sorry, I tried that, Excel returns "cannot find a match" and nothing
change.//Christer
 
Sorry, I tried that, Excel returns "cannot find a match" and nothing
change.//Christer
Click to expand...

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
 
Ron Rosenfeld said:
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
Click to expand...
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.

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
Click to expand...

Good to hear. Thanks for the feedback.
--ron
 
Back
Top