Get A List Of Sheet Names using TEXTAFTER Function

[@axion8788]

At once, both concise and comprehensive. Your ability to frame the challenge and the solution remains unsurpassed.

[@Officeinstructor]

Thanks for the motivation

[@michaelt312]

This is beyond useful. Spectacular timing for me personally. I had no idea the list formula is possible! Thank you!!

[@Officeinstructor]

Glad it was helpful!

[@Up4Excel]

Excellent! Lovely bit of Excel 4.0 Macro language slipped in there too. I've not seen a simpler way of getting a list of sheet names than this 👍

[@Officeinstructor]

Thanks for watching

[@stevew3384]

Another great and easy to follow video, thank you. Can you make this list choose just non-hidden worksheets?

[@IvanCortinas_ES]

That's great, but I prefer the Power Query method. Thank you Nabil!

[@Officeinstructor]

You are welcome!

[@rachelsl4492]

This worked perfectly. Thank you.

[@nadermounir8228]

Thank u Nabil for this great video 📹

[@Officeinstructor]

My pleasure

[@JoseAntonioMorato]

Dear Nabil,
I made a small alteration in your formula, changing the TRANSPOSE function to the TOCOL function:
=TEXTAFTER(TOCOL(MySheets),"]") 🤗

[@Officeinstructor]

Thanks for the interaction

[@X_Forex_Trader]

السلام عليكم من اللكنه باين ان حضرنك عربى غالبا الاسم كمان مصرى
تنصحنى ايدا منين فى تحليل البيانات وخصوصا ان اللغه الانجليزيه مش قويه
احتاج منك نصيحه ان سمحت طبعا

[@Officeinstructor]

حبيبي أشرف
انا مصري و افتخر
لكن بقالي عشرين سنة في كندا و ليس عندي فيديوهات بالعربي

[@X_Forex_Trader]

@@Officeinstructor الف شكر ليك على الرد كنت اتمنى التواصل معاك قناتك جميله ومفيده خسارة ان نفيش منها عربى بس انا بتعلم منها فى الاكسيل كتيررر جدا

[@X_Forex_Trader]

@@Officeinstructor انا فرحان جداا انك طلعت مصرى والله حسيتك مش عارف ليه ❤❤❤❤