View Single Post
  #5   Report Post  
Terry Pinnell
 
Posts: n/a
Default

RogerN wrote:

Terry.

I see you have sorted it but next time don't have or remove the CSV file
extension. Excel will then not "recognise" the data and open the wizard.
Otherwise, once the Excel fiile is open, highlight the data and use Data/Text
to columns, which will open the wizard.

Either way, if you use the delimited option, you can then chose the
delimiter in step 2. This will avoid the necessity of amending the original
file.

Hope this helps.

Roger


Thanks, useful tip.

--
Terry, West Sussex, UK