Converting Text String to Separate Numbers

C

Cincy

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
get each data element into a separate field in Excel and do this so th
numbers are recognized as number. Examples of the text strings ar
listed below:
Sep11 393 DENVER -4.5 -6 -5 -6 -4
-6
01:00 394 MIAMI 38.5 37 38.5 37
3
 
Z

Zygan

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting text to numbers 3
Convert Numbers to Text 4
Converting list of numbers in Excel to a string of text in Word 2
Converting Text Services to Counts of Services 4
Converting string numbers to numbers 3
Converting numbers stored as dates to text in Excel 1
Only extract numbers from a string of text 4
Converting Numbers to Text properly 1

Top