Quote Originally Posted by lienlee
Hi,

This works perfectly, however, how can i remove column I's .txt/csv because I have it in Column J already.
Hi,

The code should already do that.

Example

Column I contains

File1.txt
File2.txt
File3.csv
File4.doc

Column I would then look like this:

File1
File2
File3
File4.doc

Column J would look like this:

.txt
.txt
.csv
(BLANK)

If you are having any difficulties, can you post an example workbook to take a look at?

Thanks

Brian