Loop through column

[Sebas123]

Hello,

I have a excel sheet that houses some wrong data in the first column. The lay-out is as following.

Column A:
1111-111111.ipt,
1111-111112.ipt,
1111-111113.ipt ect.

The amount of rows in this column is variable. (From 5 to 50).

I want to loop through the column and remove the ".ipt" in every cell. Can somebody help me with this?


Thanks,
Sebas123

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/showthread.php?t=571277