Easily change commas to new lines in Microsoft Word. Use Find/Replace and special newline char ^p

preview_player
Показать описание
Disclaimer: Boring/amateur Video. I made this for my own informational use. It was useful to me at one time... maybe it will be for you.

There are many ways you can convert a comma delimited document file into a file that's instead separated by new lines.

1) Create a computer program to do this.
2) Use macros or excel
3) Heck.. their is plenty of SAS online tools on the web/cloud
4) What I'll be talking about, using Microsoft Word on a PC (and to a lesser extent Mac) to replace commas (,) with a new line (^p).

Just do the following:
A) Copy the text you want to convert into any word document
B) Open Microsoft Word.

C) Press CTRL+H to open Find and Replace
D) Under "Find What:" type ,
E) Under "Replace With:" type ^p
use the shift + 6 = ^ carrot symbol
F) click "Replace All"

Tada! Now all the commas have been replaced with new lines.

Check out my friends website/instagram
Рекомендации по теме
Комментарии
Автор

this works for replacing periods with new lines too - thank you very much for this video. you have saved me a tonne of time. cheers!

netxchange
Автор

You might have considered this a 'boring/amateur' video, alex dude.... but as others have said before me - you just saved me hours of work today. Thank you so much.

lynerickson
Автор

You just helped me save 4hrs of work. Thank you for sharing.

miceobi
Автор

you literally just saved me a lifetimes worth of time lol everyweek i do this for my google adwords and this helps so much with time thanks bro!

SonOfGodBeats
Автор

I didn't know how to do place new lines with this tool. it was very useful thanks.

krmr
Автор

thank you! you would think as long as I've been using word I would know how to do this. so grateful there are guys like you putting these resources on youtube! keep it up! who knows what trick I might need next week.

AndraDunn
Автор

You just saved my life and you allowed me(us) to be pros 😊🎉❤

samalahoward
Автор

you just saved me a half hour of my life. thank you!

maefall
Автор

thanx for saving my time sir by giving this trick

ManojChauhan-kldh
Автор

Save you 2:29 minutes. Fine box:, Replace box: ^p
Please still upvote the video of course.

RyoSaeba
Автор

Thank you so much. you just save me 6 hours of work.

bestory
Автор

It's really very useful command, thanks

ashishchoudhary
Автор

Thank you so so so much. You save many ours of my life !!!

SkiVaso
Автор

You just saved me a ton of time today. Thanks!

philliptoole
Автор

How to add Space after commas, if it's missing

GoLongBharat
Автор

I'll save y'all even more time with ads. Replace with ^p

XJ
Автор

I have the same problem put there's spaces instead of commas, how can I do this?

wait...
Автор

If you replace the, with, ^p then you get a comma at the end of ever line so SELECT ID, NAME, DOB becomes
Select
ID,
NAME,
DOB

rolandgreystoke
Автор

great information but the sound level sucks

ahraitch
Автор

did not work for me. It just replace the comma with ^p ??

pigsoup