Text to num transfer

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?
 
C

Christer

Sorry, I tried that, Excel returns "cannot find a match" and nothing
change.//Christer
 
R

Ron Rosenfeld

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
 
C

Christer

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
 
R

Ron Rosenfeld

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
 
Top