Copy part of a Cells Text and paste using vba

[JEames]

Hi,

I know that this is probably really easy but I need help please.

Cell "B6" contains a folder location and file name as follows: \\abc002\Commercial\Live Workbooks\Test Workbook.xlsm
I want Cell A6 to contain the Workbook Name and File Extension only as follows: Test Workbook.xlsm

Any help appreciated.

 

[JEames]

Perfect!! Thank you so much and sorry it was a bit of a pain

 

[Fluff]

Glad to help & thanks for the feedback.

My fault for forgetting