text to numeric
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
|