FIND() LEN() LEFT() RIGHT() Functions Extract Text From Cells in Excel Advanced P.1

[srizki]

=REPT("EXCELLENT",100)

your teaching style is excellent.

Thanks.

[herbc325]

This was very good, however can excel do this for finds based on mulitple values? IE your looking for an "M" or "W".

[m3245w]

I found this tutorial very helpful. Thank you.

A side note: Are you aware that your pronunciation exhibits what's called the "pin-pen merger"? This might be confusing for some of your students. For example, you probably pronounce 'bit' and 'bet' with distinct vowel sounds, but 'pin' and 'pen' likely have the same vowel sound in your speech. In your tutorial you say 'enter' as 'inter', the same phenomenon. More importantly, you explain the 'len' function, but pronounce it as the 'lin' function.

[ExcelisHell]

lol, in regards to pronunciation, I don't know if that is good or bad but I am glad the tutorial was helpful for you. I've never though about this pin-pen merger concept before but it is interesting. If it's hard to understand, sorry about that, I had a crappy mic when I did my early tutorials; the new tutorials are made with a much better microphone so I hope that helps.

[Bano8117]

@ExcelisHell

Thank you for wonderful tutorial!!!

I have one problem. How to extract 3rd word from excel cell if cell contains 4 and more words? For example cell contains words: "John Robert Smith Alex Bob" and i need to extract "Smith" or "Alex" from this cell. Thank you in advance!!!!

[pakapaca]

GOOD tutorial- THX!

[2handsclapping]

This is extremely clear and concise, an absolute pleasure to follow. Thank you for you generous work.