One way is to use a formula.

With the path in A1, I used this formula in B1:
=MID(A1,LOOKUP(2,1/(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="."),
ROW(INDIRECT("1:"&LEN(A1))))+1,255)

(all one cell)



rochelles wrote:

I have an excel spreadsheet with 1000's of rows. One of the columns is
file path, I need to copy the file extension and paste it into a blank
column. I was able to create a macro that will do it for one cell, but
I need it to repeat throughout the entire worksheet. Any suggestions???


--
rochelles
------------------------------------------------------------------------
rochelles's Profile: http://www.excelforum.com/member.php...o&userid=27802
View this thread: http://www.excelforum.com/showthread...hreadid=473089

--

Dave Peterson