Convert text to columns in Excel 

I just logged in to say thank you. You made my night and I have exame tomorrow. Excel is killing me. Thank you, sir!

I comeback to this vid every few months, thank you dude.

Very clear, detailed instructions. Thank you.

Here to say thank you. The best video so far on this topic. You saved me a lot.

OMGosh! This is exactly what I was looking for!!! Thanks man!

GREAT VIDEO!!! So easy to understand!!! Thank you for that!

I use this technique to consolidate different invoices at work and consolidate and report sums. Doing this would take me 10 to 15 to finish my work while my co workers would take them two hours to do manually by physically high light each invoice and ad quantities with a calculator. And i never told them my secret hahahahaha. My boss found out how I did it and had me do a presentation on how to do text to columns and pivot tables, but they didn’t feel comfortable doing it with excel and went back to doing things manually. Working with excel made me double efficient doing things way faster and accurate.

Man, in Mai 2020, I was looking desperately for this information. This saved me a lot of time. Thank you very much.

This Video saw and understand clearly. Thanks

Thank you so much!... You're such an angel. God Bless you very much

Thank you! Had a txt. file sent to me with leads and didn't know how to get em! LOL!

Easy to understand , thank you !

Thanks so much. Extremely helpful.

Thanks a million. That's brilliant. Appreciate it. Sir.

Cool! Just what I needed! Thanks!

Thank you very much, it was very hepful.

Thanks! That was very helpful

Excellent tutorial. Thank you 👍

OMG THANK YOU! I tried looking up this basic function on youtube and came across none that understood what I meant.

Thank you so much. This is very helpful.

This video is good. If u really want to get into all aspects of text to column, do search "off to office". U will become literally an expert.

Thanks you save my day and really helps a lot !!!!!!!!!!

thank you so much. your video helped me in doing my project work.

I been through loads of video's about soft . but you are the best thanks for your video's.

You made it easy to understand.

thank you so much for the nice presentation

I appreciate your help. it explains everything.

Thank you very much. Excellent!

tanks alot.............u saved my life.......this is exactly what i was looking for!!

So fuckn nice dude! i had 600 columns of numeric data from fluent in a TXT and you just saved my life.

Thank you so much! Really helped

Dank je wel, dit scheelt mij heeel veeeeel werk!

Ohh God..Thanks a lot....I was worried a lot to solve this problem

Thank you. It helped a lot

So helpful!

excellent! thank you !

thanks it helps a lot!

2008 wow.. but glad I found. Thx

Hi Dear, A nice video , it's really gr8 job Thanks, Anes

thangkyou.. u've helping me much.

Thank you!

Thank you for sharing

thanks i could finish my job properly and accurately

thankz you so much...its still helpfull :3

Thanks for this video

summary ... if you r struggling to convert text to excel ..copy ur data from text, paste it to excel then go to data tab text columns and follow instructions ... and yaaaaay !! thanks a lot

Thank you so much😍😍😍😍😍

Is there a way to choose " - "? Bands like "a-ha" or songs like "Semi-Charmed Life" will be affected,

I guess you didn't renew your domain...cause the site is down.

So thank youuuuuuuu!

Thank you

Take big hug from me thankQ so much brother ♥♥

Thank You

thanks, bro.

thank u so much

at 9/8/2020. Many thanks !

thank you

thanks bro.

thanks

How can I do this for cells I have used = to? I don't want to change that part because I want the data to update automatically from the source.

Thanks :)

Super! thanks

thanks!

awsm information

Could you have used [dash space] as your delimiter to get rid of the resulting leading spaces in the 2nd column?

Excellent

Thanks Thanks a lot

You beautiful man

Thank you so Much, helped save ££££££££££££££££££££££££

Thanks

hey thats awesome

Great

Helpfully

What if there is blank in between which cause title did not match the line?

👍

how can I do test to row ?

👍👍

Good

Classic

I don’t even have any old types of soft soft

Thank you very much for sharing, what a simple and helpful tip for a common problem.

Hello guys, I download PPC Auto Report file in txt. document and it I see asterisks * Does anyone know how can I see the keywords behind these * ? Is it something I have to convert to on my Excel (where I insert the txt.) or there in the txt. file? Thanks anyways!

What if more than 1 artist did a song?

Does anyone know how to undo it

Journey don’t stop believing

soft soft by Image-Line Software

The was one error in this example, in the example they used dash as the delimiter... in the real world you would have wanted to use dash space... this would have eliminated the space starting the second column

functionnnn

i mean thanks.....

the video it too long, the action it's self explanatory if you can answer tell me why the action deletes the dash or any other word that fallows the separation character

MUCH TALK

Nothing great in this video, just copy paste and change the delimiter. and this you have explained in 6 min.. :(

Thank you!

thank you

Thanks

Great

thank you

Thanks