Yes. Needed VBA to add to an already written macro. And Rick's code is very
quick! Didn't know DataText, though. Thanks much for the tip. Stephanie

"Gord Dibben" wrote:

Do you want VBA?

You could do the same with DataText to ColumnsDelimited by a period.


Gord Dibben MS Excel MVP

On Fri, 3 Oct 2008 16:26:00 -0700, StephCA
wrote:

Hi: Excel2003. I have a list of file names in column A (340 rows). I want to
copy the extension (only) from each name in col A to col B -- so I can sort
the worksheet by file extension. There are about 15 extensions (.xls, .doc,
.lnk etc.) Can someone provide me the VBA code, or a starting point, to do
this?

TIA, Stephanie