View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CPower[_16_] CPower[_16_] is offline
external usenet poster
 
Posts: 1
Default notepad to excel spreadsheet

Hi Guys,

I got a notepad file with 100s of lines of numbers that look like this
2004, 3, 23, 9, 43, 24

I need to transfer these into an excel spread sheet, but how do i mak
excel recognize each column as been seperated by a comma, e.g.
2004 in col a
3 in col b
23 in col c
etc.

Thanks in advance,
Cathal

--
Message posted from http://www.ExcelForum.com