Excel formula challenge: Reverse words in a string

preview_player
Показать описание
Reverse words: This video shows how to split text by a delimiter and recombine in reverse order. A relative simple problem with a simpler solution

00:00 Introduction
00:30 Problem description
01:10 Explanation of solution concept
02:55 Solution walkthrough
04:56 Extending single formula to multiple cells
07:28 Formula cleanup

Link to workbook:

Link to Excel challenge:

#Reverse #ExcelFormulas #FormulaBreakdown
  1. ExcelMoments
  2. Excel
  3. Excel functions
  4. Excel formulas
  5. TEXTJOIN
  6. ARRAYTOTEXT
Рекомендации по теме
Excel formula challenge: 0:08:15

Excel formula challenge: Reverse words in a string

Reverse text string 0:01:21

Reverse text string in excel | Reverse text string formula | #ritikadeducation

Reverse Text String 0:04:24

Reverse Text String in Excel। Microsoft Excel। Excel TOP Formula।

#EXCEL | REVERSE 0:00:48

#EXCEL | REVERSE TEXT TRICK | #shorts #shortsvideo #Shortsfeed #youtubeshorts 🔥

Excel Formula Challenge: 0:07:03

Excel Formula Challenge: missing alphabets

Reverse Text String 0:03:44

Reverse Text String (Without VBA) Using Formula or With VBA Using StrReverse Function | Mirror Text

Excel - Reverse 0:10:45

Excel - Reverse A Column In Excel - With Mike Girvin - Duel 196 - Episode 2446

Reverse list in 0:02:41

Reverse list in Excel formula - Advance Function

IQ TEST 0:00:29

IQ TEST

Reverse String Using 0:00:56

Reverse String Using REDUCE Function in Excel

EXCEL CHALLENGE: Palindrome 0:19:27

EXCEL CHALLENGE: Palindrome & Perfect Divisibility Check (Formula Fun!)

Excel - Solving 0:18:39

Excel - Solving Word Search With Excel (FMWC) - Episode 2439

Use Some Creativity 0:00:27

Use Some Creativity In Excel Sheet 😎🔥🔥 || Subscribe for More Tips and Tricks 🔥🙌

Reverse a Formula 0:06:19

Reverse a Formula in Excel using Excel Goal Seek | Vivekananda Sinha | Video 194

Word Search challenge 0:43:12

Word Search challenge in Excel - from FMWC Battle of 16 semi-finals

Challenge - Reverse 0:11:38

Challenge - Reverse text

How to Split 0:10:54

How to Split and Transform Text in Excel (Unbelievable Power Query Tricks)

SUM + VLOOKUP 0:00:35

SUM + VLOOKUP Formula In Excel #excel #exceltips #shorts #exceltutorial #msexcel #microsoftexcel

Three Ways To 0:06:07

Three Ways To Do Lookups And Reverse Lookups In Excel

Excel Formula Challenge 0:15:47

Excel Formula Challenge - REDUCE function for Pascal Case to Snake Case

XLOOKUP Function in 0:00:53

XLOOKUP Function in Excel

How to Use 0:10:22

How to Use Excel's New TAKE Function to Impress Your Boss and Colleagues

ALL YOU NEED 0:00:22

ALL YOU NEED IS ONE CURRENCY PAIRS TO BECOME A PROFITABLE TRADER (Forex market liquidity)

computer typing speed 0:00:16

computer typing speed 50wpm /classes available

Комментарии
Автор

I find these videos hypnotic - very well made, and it’s enjoyable to watch a master craftsman at work!

charlesmurtaugh
Автор

Excellent video Victor, you surpass yourself all the time, a real pleasure!

waitplanwp
Автор

Excellent explanation.
These challenges are very good to unblock the mind. Thank you Victor.

IvanCortinas_ES
Автор

Great explanation as expected from you...thank you sir.

sunnybaggu
Автор

Good morning, Victor. Very elegant approach as always, my friend. The best part of the video is your train of thought on how to resolve the problem piece by piece using bits of formula and then put them all together... instead of doing formula gymnastics in one shot...and that will really discourage the learning experience. Thanks for posting. I am watching and replicating on my own all your formula challenge series.

jazzista
Автор

Dear Momoh,
I am extremely grateful for your videos.
I have a workbook, with several worksheets, which I named Momoh Curiosities. 😀
You've been inspiring me a lot. 🤗

JoseAntonioMorato
Автор

Very impressive as usual Mr. Victor. I'm having issues with the REDUCE HSTACK solution.

quadriatharutech
Автор

Thank you so much, Victor.
Can you help me check why this approach doesn't work?
=SORTBY(TEXTSPLIT(A2, ", "), COLUMN(TEXTSPLIT(A2, ", ")), -1)

I have done it differently but it's not working when I write the formula together.

I'm just trying to understand these formulars better.

Thank you and well done.

ogunronbitaiwofisayo
Автор

I have tried to copy the formula exactly is as listed, even using the test excel file with the fruits, checked every character but it only gives me an the following: Error
SORT expects all arguments after position 1 to be in pairs 😪

rbrbeb
Автор

Thanks Victor, another well explained video

stevereed