Extract Last Name using the TEXTAFTER function in Excel. 🍐Join my online course on Excel Tables 🤍🤍udemy.com/course/tables-in-excel/?referralCode=692FAFD07AA4149E96D0 🍓Download my free eBook on Excel Macros 🤍eepurl.com/gpT0RD 🍇Check these Books on Excel 🤍xlncad.com/excel-resources/ 🍉Read my articles on Excel 🤍xlncad.com/ 🍏Playlist for Shorts on Excel 🤍🤍youtube.com/playlist?list=PLOpSTK2dKjqJYObfdAjr6Xhv-GMigo7Kx #excelshorts #exceltip #exceltrick
Hi I have bill no and Date both are joint like bill no 104/22-22/date I want remove date how I can do
Thanks alot, so helpful
Flash fill is quick
Will it work in date and time to
How to select only for alphabets from the surname.
Power query is another option... Transform, split columns, delimiter
I don't have this option in my version
HOW TO SEPARATE FATHERS NAME FROM A ,B,C SS/O C
Or you can use left or right function
Not working on 2010 excel
What version of Excel is this
You can also use right and lens function
How about if the name is Robert De Niro, De Niro is the last name.
How to convert same formula into a shape made text, for any kind of poster making
Rao kri kum giri
Ram rao Kri
What if we need middle name and first name
Thanks..last and first one is easy than mid
someone explain why -1?