Automatically translated.View original post

るん|簡単Excel時短術

1597 followers

Follow

Follow

Follow

649 saved

287

Splitting line feed data, this is the fastest!

Other posts @ run.excel ⬅️ time saving from here

[Procedure]

1. Select a range (shift + ctrl + ↓ to select all the way to the bottom)

2. Click "Separator Position" on the Data tab

3. Select "Separators such as commas and tabs..."

4. Next

5. Other checks

6. Press Ctrl + J (you can specify a line break)

7. Click Finish

8. Click OK

9. Complete!

------------------------------------------------------

This account (@ run.excel) is

\ Don't be late for pick-up time 🏃‍♀️💨 /

🤯 can not be solved in an instant

🕔 time to go home

👩🏻‍💻 in 5 minutes

I would be happy if I could go home earlier than usual and help make time for myself 🫶

Autumn that evolves me Convenience of Excel # split newline data # excel _ beginner # work efficiency

2025/11/3 Edited to

Excelで改行を使ったデータ分割は、業務効率化にとても役立ちます。私も以前は手作業で一つずつデータを分割していて非常に時間がかかりましたが、この方法を知ってからは一気に作業が楽になりました。今回の手順では、Ctrl+Jというショートカットキーを活用して改行コードを区切り文字に指定します。この操作で、改行を区切りポイントとして簡単にデータを分割可能です。普段使っている住所や名前、生年月日などのリスト処理に最適で、データを1つずつコピー＆ペーストする手間もなくなります。また、データが大量にあっても、Shift+Ctrl+↓で範囲を一括選択できるため、操作もスムーズです。OCRで読み取った例のように、名簿や住所録のデータもこの方法なら一瞬で整理できます。使い方をマスターすると、急ぎの仕事や突発的な依頼にも即対応できるようになり、毎日の仕事で自分の時間や余裕が増えるのを実感しています。ぜひエクセル初心者の方も一度試してみてください。

Related posts

1 like

STOP being roommates with your SO 🖤💝🌸

WHAT IS THE ROOMMATE PHASE? The roommate phase can happen when you live with your partner for a while and you start to feel more like roommates rather than romantic partners. WHAT YOU MIGHT EXPERIENCE.. - You feel less connected to your partner - You are less intimate (both physically and em

3673 likes

#periodictable #study #learning #science

382 likes

I want to be honest that I do not have a perfectly curated hair growth diet. I eat like a real person with a real life and real time constraints. But learning which foods actually support hair growth from the inside changed how I think about what I eat and I want to share that with you because I t

3 likes

The power of gratitude journaling for alignment

Gratitude shifts your reality. The more you focus on what’s already beautiful in your life, the more beauty you attract. It’s not about ignoring what you want—it’s about making space for it by appreciating what’s already here. Your energy is magnetic. A woman who moves with gratitude attracts ab

35 likes

Here’s a simple breakdown of how affiliate marketing works 👇🏼 1️⃣ Go to Digistore24 2️⃣ Create a free account 3️⃣ Open the affiliate marketplace 🛒 4️⃣ Pick a niche (a topic you’re interested in) 5️⃣ Choose a product in that niche 📦 6️⃣ Grab your unique affiliate link 🔗 7️⃣ Find free images

99 likes

Why does brain freeze happen? #doctor #health #medical #science #brainfreeze

1 like

An open Bible with highlighted verses and handwritten notes about Jacob's story, including his fear of Esau and preparations for their meeting. The notes are written in various colors and styles, with some sections outlined.

A notebook page displaying handwritten scripture notes. It features Romans 12:2 about transformation, and notes on Amos and Samuel, discussing God's love, worship, and the importance of a sincere heart.

A notebook page with handwritten notes detailing the story of Isaac and Rebekah from Genesis 24. The story is broken down into steps, describing Abraham's deal, the servant's journey, Rebekah's actions, and their eventual marriage.

cute scripture note inspo:

here’s some journal ideas!

25 likes

i really thought we’d make it this time guys… 😀😢 @Kleine @Karley Swindel @Anna Kate #tiktoklesskelee #olympics #dcc #dallascowboyscheerleaders #olympics2026

70 likes

People tend to ask me how i do an order , get kids feed & in bed ? well here’s the raw truth 😩🤣🤣 also if you wanna know how you can save you funds splitting your rent in 2 payment month watch till end 💋🥰 #Fypviral #RelatableMomContent #Grwm #MomsSupportingMoms #momlife

61 likes

Borderline Personality Disorder.

#fyp #bpd #bpdtiktok #bpdawareness #mentalhealth

87 likes

6 likes

The energy? Too high. The logic? Too low. Chill. #fypシ゚viral #fyp #foryoupage #fyppppppppppppppppppppppp #magaisacult

1148 likes

3 likes

8 likes

FL16 Is Winnable If We Stop Splitting the Same Vot

This isn’t about party loyalty — it’s about math and reality. FL-16 is winnable if we stop splitting the same voters. Collaboration beats complacency, and waiting only hands the seat back to the incumbent. Bradenton, Palmetto, Parrish, Riverview, Brandon — this is our moment.

1 like

You stop pretending you’re okay. You release what’s draining you. You choose silence, rest, and truth. And little by little… you come back to yourself. #pisss #trust yourself #fypシ゚viral

7 likes

How I Actually Grew My Natural Nails🫶🏼

Let’s Be Real…Long, healthy natural nails don’t come from luck alone. Some women naturally have long, thick, strong nails without doing anything, and genetics can play a role. But that wasn’t my story. I didn’t always have nails like this. I only started growing them about two years ago, and they a

446 likes

what filing actually does to the edge 💅

People love to say file in one direction, but almost no one explains why. Your free edge is made of layered keratin. It is not one solid piece. When that edge is filed too aggressively, especially with a rough file and too much pressure, tiny fractures and fraying can start before you even see v

88 likes

Finding Balance in Marriage Isn’t Easy, But….

Let’s be honest…..life will have you juggling everything at once. Kids, work, bills, health, goals… and in the middle of all that, your marriage can start feeling like it’s somewhere at the bottom of the to-do list. There was a time my husband and I were both just… existing in the same house. We

14 likes

Kandi Burruss and Todd Tucker are splitting up aft

Kandi Burruss and Todd Tucker are splitting up after nearly 15 years

14 likes

Stop Splitting Wood: Teach Kids to Use a Drill

Most kids aren’t lacking ability, they’re lacking exposure. If we never hand them real tools, we can’t expect real skills. A split piece of wood isn’t failure, it’s feedback. This is how kids learn patience, problem-solving, and confidence that actually transfers to real life. Screens aren

46 likes

The sudden splitting headache serves as a reminder

82 likes

#Wildlife #AnimalDocumentary #NatureDocumentary #WildlifeVideo #fyp

32 likes

Underrated DBT technique to use with BPD Patients

Remember that every Patient encounter can be therapeutic

3 likes

Meghan BREAKS SILENCE — Lawyers on Standby After Explosive Claims #new #royal #royals #viral

0 likes

Heathy advice 💕

Something for everyone❤️ #homeremedies #naturalremedies #healthbenefits #naturalremedy #naturalmedicine #healthtips #remedy #healthiswealth #holistichealth #remedies

19 likes

A cover image featuring Hiccup riding Toothless, a black Night Fury dragon, against a sunset sky. The title 'HTTYD book of dragon pages!!' is prominently displayed.

An illustration of a Monstrous Nightmare dragon with text detailing its fire breath, physical attacks, agility, and ability to engulf itself in flames using secreted flammable gel.

Illustrations of Skrill dragons, described as secretive creatures that ride lightning bolts and shoot white fire. Statistics include Class: Strike, Fire type: Lightning, and various physical features and abilities.

HTTYD book of dragon pages!!

21 likes

Storytime:I had a boyfriend for less than 24-hours

Part 1. Yup, you heard that right! And it all went downhill. Since Lemon8 has a 1-minute video limit, I’m splitting this story into 5 parts. #storytime #storytimes #relationship #safespaceforgirls #safespace

163 likes

balancing work vs. baby 👶

39 likes

BPD splitting techniques I’ve learned 🖤

hope these are helpful !! 🥀 #bpdsplitting #bpdsymptoms #bpdsupport #bpdawareness #bpd

1 like

Most hikers fear wildlife…but the stuff that actually ruins hikes (and sends people to urgent care) is way more common. These are the 5 highest probability trail dangers most hikers will deal with eventually, and what to do about them: 1) Ticks Tiny, easy to miss, and not something you want

3 likes

PART 12👀☕️ #fyp #channeledmessage

5 likes

4 likes

There's Something Sinister behind the Anthony Joshua Crash #anthonyjoshua #jakepaul #boxing

1 like

Hoodoo Taboos (Splitting Poles)

🚩Hoodoo Taboo: Splitting the Pole 📫 When you’re walking with someone and you both have to split up to get around an object—a lamppost, a fire hydrant, a mailbox, or even another person—that’s what people in Hoodoo call “splitting the pole.” One person goes to the left, the other goes to the right,

34 likes

Difference between Lane Splitting and Filtering?

6 likes

What you don’t feed can’t survive.✨

Attention is power. ✨ #QuantumGlowUp #RealityStarvation #ManifestationMindset #EnergyWork #MindsetReset https://www.amazon.com/7-Day-Mindset-Reset-Journal-Reconnect/dp/B0FZCY1DD3

0 likes

A desk setup featuring a laptop displaying Anki Pro with anatomy flashcards and a tablet showing Quizlet with photosynthesis study terms, illustrating active recall study apps.

A laptop screen shows the Anki Pro app with anatomy flashcards. Overlay text highlights Anki Pro's use of active recall and spaced repetition, noting its learning curve compared to Quizlet.

A tablet displays the Quizlet app with study terms on photosynthesis. Overlay text describes Quizlet as having various learning modes, a fun interface, and being easy for on-the-go study.

active recall study apps 💯🎧💗

active recall study apps 💯🎧💗 - quizlet - anki pro active recall is a study technique that has you “test” your knowledge over a set period of time. this can be in the form of flashcards, creating your own practice problems, etc. this method is one of the best ways to memorize things quickly!

593 likes

See more