Excel, after spilt column, how can I get the last part of a path in a new colum?-CodePudding

I have just spilt a path in columns. I would like to take just the last part of every row, just the name of the filename(.doc or .pdf) and cut and put in a new column.

How can I do it in excel?[![enter image description here][1]][1]

Thanks [1]: https://i.stack.imgur.com/FWAsN.png

CodePudding user response：

Use find to locate the . then use mid to extract the extension.

=MID(A1,FIND(".",A1,1),LEN(A1) - FIND(".",A1,1)   1)

CodePudding user response：

=LOOKUP(2,1/(A2:E2<>""),A2:E2) entered with ctrl shift enter and copied down.