I think there's no need to bother removing the spaces first. Even less
typing!

"Pete_UK" wrote in message
...
Highlight the column containing the data (column A?), then click on
Edit | Replace:

Find what: <space
Replace with: leave blank
click Replace All.

With the column still highlighted, click on Data | Text-to-columns,
choose delimited with - as the delimiter, and specify B1 as the
destination.

Very little typing ...

Hope this helps.

Pete

On Dec 19, 3:00 pm, wrote:
Hi,

I have the following text: "34.00 - 39.50". Is there a way to convert
them into numerics format? Ex: 34.00 in B1 and 39.50 in C1, without
typing?

Thanks