text to numeric

  • Thread starter Thread starter luistotonho65
  • Start date Start date
L

luistotonho65

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

Great, Pete !

You solved my problem.

Thanks
 
Back
Top