Thread
:
Changing text to value
View Single Post
#
5
Posted to microsoft.public.excel.misc
Pete
Posts: n/a
Changing text to value
Here's another very quick way I picked up a week or so ago:
Highlight the column that you want to convert
Click Data | Text-to-Columns then click Finish
Repeat for any other columns.
Hope this helps.
Pete
Reply With Quote