Help in split formula

[Jagdev Singh]

Hi Experts

I have list of numbers in a column which ends with .docx. I need only the number above the ".docx".

Ex - 11133J15_000001ABC.docx

I am trying the LEFT formula - =LEFT(A2,SEARCH(".docx",A2))

Output is = 11133J15_000001PRM.

I dunno want "." at the end.

 

[PaulF]

Here you go...

=LEFT(A2,FIND(".",A2)-1)

Respectfully,
PaulF

 

[Khalid NGO]

Hi JD,
Just add -1 at the end of Search formula:
=LEFT(A2,SEARCH(".docx",A2)-1)

Regards,


Edit: Didn't Notice PaulF already replied.

 

[Somendra Misra]

Hi Jagdev,

Just another option as there is one pattern:

=SUBSTITUTE(A1,".docx","")

Regards,

 

[Jagdev Singh]

Hi Somendra, Khalid & Paul

Thanks for the formulas.

Regards,
JD