text to numeric
 

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

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

text to numeric
 

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

text to numeric
 

On Dec 19, 1:13 pm, Pete_UK wrote:
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

Great, Pete !

You solved my problem.

Thanks

text to numeric
 

On Dec 19, 1:31 pm, "Stephen" <none wrote:
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


Yes Stephen, you´re right.

Thanks

text to numeric
 

Glad to hear it - thanks for feeding back.

Pete

On Dec 19, 3:34 pm, wrote:

Great, Pete !

You solved my problem.

Thanks