removing a back slash from excel

[esb128]

I need some help on trying to create a formula to remove everything in a cell before the last backslash, including the last back slash can someone help me? I have 15,000 of these lines thank you!!

example :

Y:\marketing\ADVERTISING\Graphics\Scanned Images\Color\Boss\adapters\boss adapter_GFAS26.tif needs to equal: boss adapter_GFAS26.tif

<tbody>
</tbody>

 

[Snakehips]

esb128,

WElcome to MrExcel.

Try....

Excel 2007
	A	B
1	Y:\marketing\ADVERTISING\Graphics\Scanned Images\Color\Boss\adapters\boss adapter_GFAS26.tif	boss adapter_GFAS26.tif
Sheet5

Cell Formulas
Range	Formula
B1	=TRIM(RIGHT(SUBSTITUTE(A1,"\",REPT(" ",99)),99))

Hope that helps.

 

[Marcelo Branco]

Hi and welcome to Mr Excel

Maybe...

B2
=TRIM(RIGHT(SUBSTITUTE(A2,"\",REPT(" ",500)),500))

M.

 

[esb128]

Wow, you guys are great that solved my problem and many hours of find/replace. Thank you!