Have you ever been stuck with a “comma delimited” txt file that is almost impossible to work with?
Working with one GIANT block of text in a txt file is a nightmare, but luckily, it’s pretty easy to copy and paste all the data and organize it with ease in Microsoft Excel (or for that matter, Google Sheets). Just follow these steps:
– Copy and paste all of the text into a new excel file
– Highlight the column that contains your list (in this example, column A).
– Go to Data (in the toolbar), then click on “Text to Columns”
– Choose Delimited. Click Next.
– Choose Comma. Click Next.
– Choose General or Text, whichever you prefer.
– Leave Destination as is, or choose another column. Click Finish.
Give it a try and you’ll see what I mean – it’s pretty easy!
20 comments
THANK YOU ALOT
Thank you so much. You are a live saver.
Thank you that was fast and helpful
Just what I needed, thanks!
Thanks
Saved my life , thanks mate 🙂
thank you very much
Great Tutorial!
Hey Hello Sir,
I am trying to make comma separated number if number greater than 999 like 111.111 to 111.111 but 99999999.9999999 to 99,999,999.99999999(after decimal whatever the value are in file)and there are 1 column name x which have this type of value
Can you please help in this??
Thank you so much !!! U saved me hours !! Liked and subscribed to your channel
Thanks a lot for this video. Precise and to the point!
data cleaners, here we go!!!!
You just saved me so much time! Thank you!!
You saved my life bro <3
May there be a place for you in the Kingdom of God. 🙂 !!!!!!
Man, You're definitely worth the Hammer of Thor!)) Thanks a LOT!
Like the way you simplified it with the 3 names example too. Learnt something handy today and saved me a bunch of time. Thanks
I've don't this since the early '90s, but by importing the textfile — not copy pasting. This has been preferred as I sometimes need to paste a couple of million rows. Copy / paste doesn't like that kind of massive dataset. Sadly Microsoft has ruined the file import dialog in version 2110 14527.20226. The import doesn't allow for more than six columns of import.
Thankyou brother 🙂
Thank you!!! This was very helpful Sir.