Excel formula challenge: route cipher formulas

preview_player
Показать описание
route cipher formulas: Just a simple Excel cipher formula to transform a string by breaking it into n columns and stacking up text ina predefined order

Link to Excel workbook:
  1. ExcelMoments
  2. route cipher formulas
  3. Route
  4. cipher
  5. formula
  6. route cipher
Рекомендации по теме
Excel formula challenge: 0:10:37

Excel formula challenge: route cipher formulas

Excel BI Challenge 0:05:58

Excel BI Challenge 178 - Route Cipher

Excel formula challenge 0:12:39

Excel formula challenge - Top 2 Runners up (No wins)

Excel Formula Challenge: 0:07:03

Excel Formula Challenge: missing alphabets

Excel formula Challenge 0:03:54

Excel formula Challenge -Greatest common divisor (CoPrimes)

Excel formula Challenge 0:12:59

Excel formula Challenge - Most country pairs in FIFA WorldCup Finals

Excel Formula Challenge 0:15:47

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

Caesar and Decimation 0:20:02

Caesar and Decimation Ciphers on Excel

Use Some Creativity 0:00:27

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

Excel formula challenge: 0:08:15

Excel formula challenge: Reverse words in a string

Excel Formula Challenge 0:19:00

Excel Formula Challenge - Reduce function to Align Cities

5 Tricks to 0:00:54

5 Tricks to Become an Excel Wizard

SUM + VLOOKUP 0:00:35

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

Excel formula challenges 0:10:31

Excel formula challenges - Isograms

Excel Formula Challenge: 0:12:36

Excel Formula Challenge: List repeated Alphabets from text string

XLOOKUP Function in 0:00:53

XLOOKUP Function in Excel

How to FILTER 0:00:57

How to FILTER with Multiple Criteria in Excel #shorts

MS Excel LOOKUP 0:01:00

MS Excel LOOKUP Formula: Return Multiple Values

Cryptography in Excel 0:15:22

Cryptography in Excel | Ciphertext & Plaintext Calculator | How to use | Free download

Use Of Flash 0:00:17

Use Of Flash Fill In Excel | Split First Name And Last Name Flash Fill @BrainUpp

Top 25 Excel 0:03:19

Top 25 Excel Formulas Learning - 25 Day Challenge - Day 23- SUMIF() Formula #gokultech

EXCEL CHALLENGE: Crack 0:15:21

EXCEL CHALLENGE: Crack the Code! Decode Resistor Colors with an EPIC Formula! (Advanced Functions)

Excel Job Interview 0:00:27

Excel Job Interview Questions Data Entry in Excel #excel #microsoftexcel #excel #exceltutorial

4 GREAT Ways 0:01:00

4 GREAT Ways to Hide Values in Excel #shorts

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

Fantastic resolution. The use of WRAPROWS in the exercise is excellent. Thank you Victor!!!

IvanCortinas_ES
Автор

Dear Momoh,
Before seeing your solution I developed mine that was not so good, but it also works:
=MAP(A2:A7, B2:B7, LAMBDA(a, b, CONCAT(TOCOL(WRAPROWS(TEXTSPLIT(TEXTJOIN(" ", , MID(a, SEQUENCE(LEN(a)), 1)), , " ", 1), b, ""), 1, 1)))) 🤗

JoseAntonioMorato
Автор

Nice video again Victor. To make it easier to read, it might be better for you to separate the formula onto different lines. I'd also be interested to see how you reverse it to get the original text back!!

stevereed
Автор

Bros you are speaking over my head 😢. I need to go through foundation classes first

michaelomazi