up vote 0 down vote favorite
share [g+] share [fb]

I have a column containing file paths. I want to make another column which contain the extensions of the paths only. How can I do this in Microsoft Excel?

link|improve this question
67% accept rate
feedback

2 Answers

up vote 5 down vote accepted 
=REPLACE(RIGHT(A1,5),1,SEARCH(".",RIGHT(A1,5)),"")

This formula wil be useful if you have more than one dot in filename

link|improve this answer
Thanks Cyril. Your math is brilliant! – Nam G. VU May 17 '10 at 9:04
feedback
up vote 1 down vote

Assuming you have nicely formatted extensions, you can do this quickly as =RIGHT(A1,3). A more robust solution would find the index of the rightmost . and then extract the remaining characters.

link|improve this answer
Reading your question that is the answer I would have given. – VerGuy May 17 '10 at 6:59
I think the real question here is: how to find the rightmost "." in Excel. – petersohn May 17 '10 at 7:06
The extension is not alsway in 3 characters. @pertersohn: Yeah, you're right. – Nam G. VU May 17 '10 at 8:58
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.