importing

[jochem]

I imported a spoolfile with text to colums in Excel.
But because there are spaces in the cells, numeric values
are not recognised. For instance, if i select a range and
change the numerformat to **,***.** this has no effect.
The workaround is to select the cell, click in the
formulabar and <enter>.
After this the spaces disappear and the numeric value is
recognised. Is there a solution that cost me less time?

 

[Edmund Seet]

jochem,

If there's really any space in a cell, u can remove the
space by using Edit | Replace.

In the Replace dialog box......
Find What: <space> ie. hit the space bar once
Replace With : <blank> ie. delete any possible character
to the left of the blinking cursor

HTH
Edmund Seet

 

[Mark]

You could try using the TRIM function which should remove
spaces from a cell

Example : Cell A1 contains " 3"

Formula entered in next cell =TRIM(A1)+0

The +0 at the end will force Excel to display the result
as a number.