| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting Text String to Separate Numbers
I copied some information from a website directly into Excel. However, all the numbers are included in one cell as a text string. How do I get each data element into a separate field in Excel and do this so the numbers are recognized as number. Examples of the text strings are listed below: Sep11 393 DENVER -4.5 -6 -5 -6 -4 -6 01:00 394 MIAMI 38.5 37 38.5 37 37 -- Cincy ------------------------------------------------------------------------ Cincy's Profile: http://www.excelforum.com/member.php...o&userid=35172 View this thread: http://www.excelforum.com/showthread...hreadid=549388 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting Text String to Separate Numbers
try click on the cell and then click on DATA TEXT TO COLUMNS then you have two choices Delimited wher spaces or commas or / marks will serperate the text into cells or you have the option of fixed with wher you can move the vertical lines to split the cell -- Zygan ------------------------------------------------------------------------ Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423 View this thread: http://www.excelforum.com/showthread...hreadid=549388 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find & Replace text format | Excel Discussion (Misc queries) | |||
| Converting text string to a its proper time format | Excel Discussion (Misc queries) | |||
| Converting text to numbers | Excel Worksheet Functions | |||
| Converting selected section of text to numbers | Excel Discussion (Misc queries) | |||
| Converting text to numbers | Excel Discussion (Misc queries) | |||
Linear Mode
