extract value

[ramco1917]

Hi

I want to extract value after last - in other column

PB-JK-25-4200145

Thanks

 

[Joe4]

What version of Office/Excel are you using?
The newer versions have some really cool new text functions, so the answer we give you may depend on which version you are using.

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[AhoyNC]

As Joe4 points out it depends on your Excel version.
Formula in B1 will work if you have the TEXTAFTER function. If not try the formula in B2.

Book1
	A	B	C
1	PB-JK-25-4200145	4200145	Newe ver of Excel with TEXTAFTER function
2		4200145	Should work with older ver. of Excel
Sheet1

Cell Formulas
Range	Formula
B1	B1	=TEXTAFTER(A1,"-",-1)
B2	B2	=TRIM(RIGHT(SUBSTITUTE(A1,"-",REPT(" ",LEN(A1))),LEN(A1)))

 

[Scott Huish]

If it's always the same number of characters before the last hyphen, you could also do this:
=REPLACE(A1,1,9,"")

 

[Peter_SSs]

If it's always the same number of characters before the last hyphen,

.. or if it is always the same number of characters after the last hyphen, you could also use this
=RIGHT(A1,7)

.. which all goes to emphasise, one example is not much to go on. A variety of samples that shows any variations in original data and/or expected results is much better.