r/excel•
Tombie13

Turning Notepad file with lots of spaces indicating a table into a real table

solved

Excel realizes .csv tables created in notepad properly when there is a , between each column
However as there is a lot of data and multiple columns adding a , manually between each data is not an option. If I import it as a csv file currently it will realize different rows, but put all data into the first column with lots of spaces in between. Is there any easier solution making this notepad file into a proper usable table?

Posted May 20, 2022, 8:31 AM UTC

18
Loading comments…