Convert text to columns in Excel

ShowMeAcademy.com - Convert text to columns in Microsoft Excel 2007

[@carlingas666]

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.

[@genofgod]

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

[@SIMRANKAUR-eg7nc]

I have really racked my brain a lot going one videos to another. I came across a channel "off to office". Delimiters,fixed width, qualifier, dd.mm.yyyy to dd/mm/yyyy everything have been explained in one single video

[@territurner727]

Very clear, detailed instructions. Thank you.

[@kwabenadavid7802]

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

[@ratedrko1249]

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

[@mj4732]

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

[@mikalmccray1632]

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

[@realisticfacts5213]

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

[@SIMRANKAUR-eg7nc]

I have really racked my brain a lot going one videos to another. I came across a channel "off to office". Delimiters,fixed width, qualifier, dd.mm.yyyy to dd/mm/yyyy everything have been explained in one single video...

[@zaimabarrero7022]

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

[@PankajPankaj-vk8md]

This Video saw and understand clearly. Thanks

[@youstinamansour9829]

Easy to understand , thank you !

[@sierracinclid]

Thanks so much. Extremely helpful.

[@winais6007]

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

[@happycrapper001]

Thanks! That was very helpful

[@spadds]

Cool! Just what I needed! Thanks!

[@naplesmilimo382]

Thank you very much, it was very hepful.

[@oseatuinivanua1909]

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

[@TracyAllen]

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

[@SIMRANKAUR-eg7nc]

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.

[@babyboo3236]

Excellent tutorial. Thank you 👍

[@shamamuri]

Thank you so much. This is very helpful.

[@jemimahkari5220]

Thank you so much! Really helped

[@biplovroy6008]

thank you so much for the nice presentation

[@chrisknotts960]

You made it easy to understand.

[@sundasshareef8691]

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

[@DiegoLopez-np7bz]

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

[@navpreetkaur5121]

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

[@kimho1545]

I appreciate your help. it explains everything.

[@aaronholcomb8609]

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

[@TracieDavissuccesscoach]

Thank you very much. Excellent!

[@Hassan-zw7jj]

So helpful!

[@vanepan]

Dank je wel, dit scheelt mij heeel veeeeel werk!

[@RachidPardoTV]

+Linda Vaneker-Pannekoek ha ik denk niet dat hij nederlands verstaat. maar ik ben hem ook dankbaar. Zo lang geleden voor mij.

[@SIMRANKAUR-eg7nc]

I have really racked my brain a lot going one videos to another. I came across a channel "off to office". Delimiters,fixed width, qualifier, dd.mm.yyyy to dd/mm/yyyy everything have been explained in one single video.....

[@linawinardi7961]

thanks it helps a lot!

[@ripfumelosuccessmabunda5131]

Thank you. It helped a lot

[@bunnicula74]

excellent! thank you !

[@Had0ukenn]

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

[@udinbay423]

thangkyou.. u've helping me much.

[@ratikantanayak9054]

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

[@cooljenify]

Thank you!

[@princepranavan5767]

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

[@amandasmith8327]

2008 wow.. but glad I found. Thx

[@XxAlexanderProxx]

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.

[@anesp.a913]

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

[@judithmariveles60]

Thanks for this video

[@themounalisa4791]

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

[@SIMRANKAUR-eg7nc]

I have really racked my brain a lot going one videos to another. I came across a channel "off to office". Delimiters,fixed width, qualifier, dd.mm.yyyy to dd/mm/yyyy everything have been explained in one single video,

[@eyfinndrewsen9096]

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

[@SIMRANKAUR-eg7nc]

Yes u can always do this selecting - as the delimiter in other tab of the textVi column wizard.
I have really racked my brain a lot going one videos to another. I came across a channel "off to office". Delimiters,fixed width, qualifier, dd.mm.yyyy to dd/mm/yyyy everything have been explained in one single video.

[@alunana6]

So thank youuuuuuuu!

[@sureshpaul2862]

thanks i could finish my job properly and accurately

[@rockrafi1032]

Take big hug from me thankQ so much brother ♥♥

[@nishanrubera5968]

Thank you for sharing

[@ibrahimamadou649]

Thank you so much😍😍😍😍😍

[@mohammedmousa3506]

Thank you

[@Qoqnous]

thanks, bro.

[@marccont01]

Thank You

[@anshulguptaji]

thank u so much

[@trinifirst6702]

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

[@siddharthadalai447]

awsm information

[@cerenademe9433]

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

[@SIMRANKAUR-eg7nc]

Why not.

[@SIMRANKAUR-eg7nc]

I have really racked my brain a lot going one videos to another. I came across a channel "off to office". Delimiters,fixed width, qualifier, dd.mm.yyyy to dd/mm/yyyy everything have been explained in one single video.

[@neferirina777]

Super! thanks

[@sayedramadan4120]

thank you

[@d-jayyy5744]

thanks bro.

[@jorgem.333]

at 9/8/2020. Many thanks !

[@alaa6976]

Thanks :)

[@sanjeethanmangalakumaran2147]

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

[@merhawighirmay3928]

thanks!

[@iibnghamd]

Thanks Thanks a lot

[@simondewaal4241]

You beautiful man

[@TheAmiCrawford]

Excellent

[@yedidiaatias4396]

hey thats awesome

[@MayurPanghaal]

thanks

[@drewdiokno6874]

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

[@purvidubey]

Thanks

[@talimhussain8378]

Helpfully

[@toeko5730]

how can I do test to row ?

[@rupeshhpatel]

Great

[@vikasraina91]

👍

[@kostasfilippopoulos8737]

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!

[@sandraseares9674]

The kon filip

[@SIMRANKAUR-eg7nc]

Use Find and replace dialogue to remove all * with nothing.

[@SIMRANKAUR-eg7nc]

Please visit channel "off to office" to know everything about text to column at one place and not in bits and pieces in different videos.

[@viratlover2289]

👍👍

[@salonipatil7018]

Does anyone know how to undo it

[@guillermollanes4314]

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

[@AlexNavarro1]

Good

[@blackman34]

What if more than 1 artist did a song?

[@nostalgiarblx5266]

Classic

[@Tristan44980]

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

[@brianshonson6246]

Journey don’t stop believing

[@suatst6935]

soft soft by Image-Line Software

[@IzAdlanChannel]

functionnnn

[@navpreetkaur5121]

i mean thanks.....

[@MichaelFetter]

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

[@domus300]

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

[@gilfulminar8976]

MUCH TALK

[@SIMRANKAUR-eg7nc]

Try this 1.
I have really racked my brain a lot going one videos to another. I came across a channel "off to office". Delimiters,fixed width, qualifier, dd.mm.yyyy to dd/mm/yyyy everything have been explained in one single video.

[@dkk351]

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

[@kamarulasyikin]

Thank you!

[@haroonch.741]

thank you

[@tauziahmed1540]

Thanks

[@LeoTriggered]

Great

[@illyneissac9500]

thank you

[@arjungandhale3273]

Thanks