• 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.

Excel formula required.

J

Jagdev Singh

Active Member
Hi Experts
Could you please help me with the excel formula which will give me the number from the below line of text.
Text - ABC Company co._11090A14_000013ABC.docx
I want number - 11090A14_000013ABC

Regards
JD
 
Hi:

Try this =TRIM(MID(A1,FIND("._",A1,1)+2,FIND(".",A1,1)+3))
If "._" and "." is present in all the strings.

Thanks
 
Hi Nebu,

Thanks for the formula,but I am getting the number with .docx is it possible to remove .docx as well from the number.

Regards,
JD
 
Hi:

I am not sure , here is what I got find the attached.

Thanks
 

Attachments

  • Book11.xlsx
    8.5 KB · Views: 1
Beside this the first digit is disappearing with the formula.

After applying the formula I should get - 11090A14_000013ABC
But I am getting - 1090A14_000013ABC

The digit "1" is missing.

Regards,
JD
 
I do not know where I am doing wrong. Please check the second row in the sheet attached.
 

Attachments

  • Sample.xlsx
    14.1 KB · Views: 1
Is there any formula to find
difference in sale per customer between the highest selling & lowest selling sales persons?
 
You must log in or register to reply here.
Back
Top