Extract

[thanksamillion101]

Hello and thanks in advance! I have tried several formulas and cannot get what I am needing.

I am needing help with extracting all information to the left of last decimal and two dashes before that decimal.
Ex:
(I need all information before) -010119-12345.pdf

I thought to use number of characters left of the last decimal, but there is not a consistency with the exact number of characters)

again, Thank you for your help!

 

[Fluff]

Can you please post 10 examples of your strings, along with the results you want?
You can use the XL2BB add-in to post the sample data to the board.

 

[thanksamillion101]

I do apologize for question and detail being so vague.

DATA Result
ON-NN-CAS-DIM-DIM-02-03152019-123456.pdf ON-NN-CAS-DIM-DIM-02
ON-NN-CAS-DIM-DIM-03152019-7891011.pdf ON-NN-CAS-DIM-DIM
ON-NN-CAS-DIM-DIM-01-03152019-123456.pdf ON-NN-CAS-DIM-DIM-01
ON-NN-CAS-DIM-DIM-03-03152019-1234.pdf ON-NN-CAS-DIM-DIM-03
ON-NN-CAS-DIM-DIM-04-03152019-1234567.pdf ON-NN-CAS-DIM-DIM-04
OFF-NN-CAS-DIM-DIM-02-03152019-123.pdf OFF-NN-CAS-DIM-DIM-02
OFF-NN-CAS-DIM-DIM-02-03152019-1234.pdf OFF-NN-CAS-DIM-DIM-02
ON-NN-CAS-DIM-DIM-06-03152019-12345.pdf ON-NN-CAS-DIM-DIM-06
ON-NN-CAS-DIM-DIM-02-031519-123456.pdf ON-NN-CAS-DIM-DIM-02
ON-NN-CAS-DIM-DIM-04-031519-12345678.pdf ON-NN-CAS-DIM-DIM-04

 

[thanksamillion101]

DATA	Result
ON-NN-CAS-DIM-DIM-02-03152019-123456.pdf	ON-NN-CAS-DIM-DIM-02
ON-NN-CAS-DIM-DIM-03152019-7891011.pdf	ON-NN-CAS-DIM-DIM
ON-NN-CAS-DIM-DIM-01-03152019-123456.pdf	ON-NN-CAS-DIM-DIM-01
ON-NN-CAS-DIM-DIM-03-03152019-1234.pdf	ON-NN-CAS-DIM-DIM-03
ON-NN-CAS-DIM-DIM-04-03152019-1234567.pdf	ON-NN-CAS-DIM-DIM-04
OFF-NN-CAS-DIM-DIM-02-03152019-123.pdf	OFF-NN-CAS-DIM-DIM-02
OFF-NN-CAS-DIM-DIM-02-03152019-1234.pdf	OFF-NN-CAS-DIM-DIM-02
ON-NN-CAS-DIM-DIM-06-03152019-12345.pdf	ON-NN-CAS-DIM-DIM-06
ON-NN-CAS-DIM-DIM-02-031519-123456.pdf	ON-NN-CAS-DIM-DIM-02
ON-NN-CAS-DIM-DIM-04-031519-12345678.pdf	ON-NN-CAS-DIM-DIM-04

 

[Fluff]

Ok, thanks for that.
How about

+Fluff New.xlsm
	A	B
1
2	ON-NN-CAS-DIM-DIM-02-03152019-123456.pdf	ON-NN-CAS-DIM-DIM-02
3	ON-NN-CAS-DIM-DIM-03152019-7891011.pdf	ON-NN-CAS-DIM-DIM
4	ON-NN-CAS-DIM-DIM-01-03152019-123456.pdf	ON-NN-CAS-DIM-DIM-01
5	ON-NN-CAS-DIM-DIM-03-03152019-1234.pdf	ON-NN-CAS-DIM-DIM-03
6	ON-NN-CAS-DIM-DIM-04-03152019-1234567.pdf	ON-NN-CAS-DIM-DIM-04
7	OFF-NN-CAS-DIM-DIM-02-03152019-123.pdf	OFF-NN-CAS-DIM-DIM-02
8	OFF-NN-CAS-DIM-DIM-02-03152019-1234.pdf	OFF-NN-CAS-DIM-DIM-02
9	ON-NN-CAS-DIM-DIM-06-03152019-12345.pdf	ON-NN-CAS-DIM-DIM-06
10	ON-NN-CAS-DIM-DIM-02-031519-123456.pdf	ON-NN-CAS-DIM-DIM-02
11	ON-NN-CAS-DIM-DIM-04-031519-12345678.pdf	ON-NN-CAS-DIM-DIM-04
Main

Cell Formulas
Range	Formula
B2:B11	B2	=TRIM(LEFT(SUBSTITUTE(A2,"-",REPT(" ",100),LEN(A2)-LEN(SUBSTITUTE(A2,"-",""))-1),100))

It's best to use the XL2BB add-in when posting data to the board.

 

[thanksamillion101]

Works great, Thank you!! You just made my job much more productive!

 

[Fluff]

You're welcome & thanks for the feedback.