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❤
Ideally you want to have formulas that work with any name and surname. So I wouldn't use numbers like 6 in your right formula because that won't work for every surname. So what you could do is work out the length of the surname which is you basically are on track to doing. The length of the surname will be the length of the whole string minus the position of the space (because the space will be everything from the first name plus the space). So you can do this: =RIGHT( I3, Len(I3) - FIND(" ", I3) ) --you can separate this into different cells if that makes it easier. This then works with text like Adam Parker (Position of space is 5, length of all text is 11 so length minus space is 11 -5 = 6 so if you copy 6 characters from the RIGHT, then you get the surname.) Note this works even if the surname contains spaces like du Preez but it won't work if there is a second name like John Paul Williamson because the space is only up until the end of the first name. Hope that makes sense.
Thank you! You're a good teacher.
I’m going to pass because of this man
!!!
You are putting in the work! You can do it. Good luck and type well!
You are awesome!!! Thank you for doing these tutorials!
Glad they can help!
Hi, is the '&' you use when you apply the functions actually concatenate?
You can use the Concatenate function or the & symbol. Both do the same thing.
Thank you@@MrLongITandCAT
Love you man❤
Thank you.
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.
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❤
Ideally you want to have formulas that work with any name and surname. So I wouldn't use numbers like 6 in your right formula because that won't work for every surname. So what you could do is work out the length of the surname which is you basically are on track to doing. The length of the surname will be the length of the whole string minus the position of the space (because the space will be everything from the first name plus the space). So you can do this:
=RIGHT( I3, Len(I3) - FIND(" ", I3) ) --you can separate this into different cells if that makes it easier.
This then works with text like Adam Parker (Position of space is 5, length of all text is 11 so length minus space is 11 -5 = 6 so if you copy 6 characters from the RIGHT, then you get the surname.)
Note this works even if the surname contains spaces like du Preez but it won't work if there is a second name like John Paul Williamson because the space is only up until the end of the first name.
Hope that makes sense.
Is the name accurate?... 😂
Finally some things being cleared out for tmrw 🥹