A common requirement in Excel is to break up the content of a cell (or range of cells) into separate cells. This video is not only about how to do that, it also covers a quirk with counting emoji characters and why getting the order right with nested functions is critical.
🗒 Notes and Resources
Download a copy of the file used in this video: app.box.com/s/5dskath1fh0bjtm...
The formulas that I used in the demos:
=LEFT(A2,LEN(TRIM(A2))-31)
=RIGHT(TRIM(A2),28)
=TEXTBEFORE(A2,": http")
=TRIM(TEXTAFTER(A2,":",-2))
✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at theexceltrainer.co.uk
🙋♂️ Let's connect on social
Twitter: / theexceltrainer
Facebook: / theexceltrainer
LinkedIn: / thomasmik
#excel #emoji #split
Негізгі бет Excel: Splitting Strings, Emoji Quirks & Nested Function Challenges
Пікірлер: 3