Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
text to numeric | Excel Discussion (Misc queries) | |||
numeric value disply in text | Excel Discussion (Misc queries) | |||
Numeric in Text to convert back to the form of Numeric for VLookup Purposes | Excel Discussion (Misc queries) | |||
Text to Numeric | Excel Worksheet Functions | |||
Convert Numeric into Text | Excel Worksheet Functions |