ExcelBanter - notepad to excel spreadsheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - notepad to excel spreadsheet (https://www.excelbanter.com/excel-programming/302426-notepad-excel-spreadsheet.html)

CPower[_16_]

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

gitcypher[_21_]

notepad to excel spreadsheet

Rename the .txt file to .csv
That stands for comma separated values.
Excel should open it up fine.

-Gitcyphe

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

CPower[_17_]

notepad to excel spreadsheet

This great thanks a million

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

All times are GMT +1. The time now is 06:43 AM.