Extract data after last slash

[FryGirl]

I know there has to be a more succinct solution than this. Any thoughts?

Data Range
[Table="class: grid"][tr][td] [/td][td]

A​

[/td][td]

B​

[/td][td]

C​

[/td][/tr]
[tr][td]

1​

[/td][td]

Path​

[/td][td]

​

[/td][td]

​

[/td][/tr]

[tr][td]

2​

[/td][td]

sites/AF-DP-00-53/ManpowerStandards/AFMS/ManpowerGuides/AFMSs_Under_Study/Maintenance Overhead (non-LCOM)​

[/td][td]

Maintenance Overhead (non-LCOM)​

[/td][td]

6​

[/td][/tr]

[tr][td]

3​

[/td][td]

sites/AF-DP-00-53/ManpowerStandards/AFMS/AirForceStandards/02-Alpha_Series​

[/td][td]

02-Alpha_Series​

[/td][td]

5​

[/td][/tr]

[tr][td]

4​

[/td][td]

sites/AF-DP-00-53/ManpowerStandards/AFMS/ManpowerGuides​

[/td][td]

ManpowerGuides​

[/td][td]

4​

[/td][/tr]
[/table]

B2 copied down =MID(A2,FIND("@",SUBSTITUTE(A2,"/","@",LEN(A2)-LEN(SUBSTITUTE(A2,"/",""))))+1,LEN(A2))

 

[Rick Rothstein]

Give this a try...

=TRIM(LEFT(RIGHT(SUBSTITUTE(A2,"/",REPT(" ",300)),300),300))

 

[JoeMo]

If it's always everything after the last slash, here's a shorter version (in B2 and copy down):

=TRIM(RIGHT(SUBSTITUTE(A2,"/",REPT(" ",100)),100))

 

[FryGirl]

Joe/Rick,

Thanks, both solutions worked great.

 

[JoeMo]

Joe/Rick,

Thanks, both solutions worked great.

You are welcome - thanks for the reply.

 

[Crystaline]

If it's always everything after the last slash, here's a shorter version (in B2 and copy down):

=TRIM(RIGHT(SUBSTITUTE(A2,"/",REPT(" ",100)),100))

Hi can I ask do i type this formula as it is on excel

 

[Crystaline]

`

 

[jtakw]

Hi,

See reply here: Extract Text before last slash

 

[JoeMo]

Hi can I ask do i type this formula as it is on excel

Copy the formula from your browser and paste to Excel.