Hi All
I have a string of text in cell A1 similar to this : C:\start\123\solidworks.slddwg (This can vary in length and contents)
In Cell B2 I have a formulae to manipulate the string to get: C:\start\123
I need to get solidworks.slddwg into Cell C2
Any ideas
Steve
I have a string of text in cell A1 similar to this : C:\start\123\solidworks.slddwg (This can vary in length and contents)
In Cell B2 I have a formulae to manipulate the string to get: C:\start\123
I need to get solidworks.slddwg into Cell C2
Any ideas
Steve