MS Excel | Text Functions

This video covers basic Text functions and formulas that are used in the spreadsheet software Microsoft Excel. This includes:
Left, Mid, Right, Len, Find, Concatenate, Value, Upper, Lower, Date

#MrLongEducation #Excel #TextFunctions

[kailynaustin]

Thank you! You're a good teacher.

[kobekaviza]

I’m going to pass because of this man
!!!

[mark_ontong]

You are awesome!!! Thank you for doing these tutorials!

[MosesKungu-cy]

Hi Mr Long I got a question for finding the domain at 14:45, could I have said =MID(I7, (N7+1))

[Danieldehahn]

Sir by the Right function isn't suppose to be Long Mr, sorry for the late reply, I only found out about your channel this week.

[MufamadiLusani]

Hi, is the '&' you use when you apply the functions actually concatenate?

[Chardo.Vissie]

Mr Long, I want to ask a question🙈

There at John Smith the Surname, you used the MID function

=MID(I3;6;100)

I instead used this method in another cell:

I said
=LEN(I3) (which gives me all the characters from John Smith)
=10

I typed in another cell find space
=Find(" ";I3)
Which also gave me 5

I then typed in the Surname field
=RIGHT(I3;6)

(I started at 6 because I don't want to include the 5 which is the space)

Is this method okay, or will I lose my marks? I did show my calculations though❤

[nicolesabuwa]

Finally some things being cleared out for tmrw 🥹