How do I convert a prn file to excel and not have all data reside in one cell. I can save it as a excel sheet but everything is in one cell. How do I split it into cells so I can work with the numbers and still have the text.
Thanks,
Rose
How do I convert a prn file to excel and not have all data reside in one cell. I can save it as a excel sheet but everything is in one cell. How do I split it into cells so I can work with the numbers and still have the text.
Thanks,
Rose
Hi,
Have you tried from menu Data Text to columns ...?
HTH
Carim
I'm sorry I don't understand menu data text to columns.
Rose
Ok ...
From Excel main menu
Select Data
within Data sub menu
Select Text to Columns ...
HTH
Carim
I got it, thanks so much.
Rose
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks