Hi All

Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

Post Spam and you Will Be Deleted as a User

Hui...
When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Fetch Department Name

Thread starter Deepak Sharma
Start date Jul 30, 2018

D

Deepak Sharma

Member

Jul 30, 2018

#1

Hi All,

Kindly help to find the department name only from cell A1.

Thanks and Regards,
Deepak Sharma

AliGW

Well-Known Member

Jul 30, 2018

#2

Try this:

=TRIM(LEFT(SUBSTITUTE(MID(txt,FIND("Department",txt)+18,99)," ",REPT(" ",99)),90))

D

Deepak Sharma

Member

Jul 30, 2018

#3

Thank you very much AliGW..

AliGW

Well-Known Member

Jul 30, 2018

#4

You're welcome!

You must log in or register to reply here.

Share:

Facebook X (Twitter) Reddit Pinterest Tumblr WhatsApp Email Link

Top