How to delete specific list of words in a column

[new2world]

Hello,

i need to know is there any method to replace or remove list of words from a column

example

95.168.183.244:3128
195.56.32.133:3128
173.3.243.226:11772
71.57.148.111:2010
69.251.1.62:1841
24.1.73.3:1774
67.189.173.51:1035
69.174.244.77:9050
76.22.161.245:1868


i want to replace or delete everything after this :
i.e 3128 , 11772,2010 etc

i have a huge list of this and i want to know how to delete everything after this :

is there any macro for this i can not use find and replace in this as there is a huge list of numbers to be replace

thanks
waiting for reply

 

[VoG]

Try like this

Excel Workbook
	A	B
1	95.168.183.244:3128	95.168.183.244:
2	195.56.32.133:3128	195.56.32.133:
3	173.3.243.226:11772	173.3.243.226:
4	71.57.148.111:2010	71.57.148.111:
5	69.251.1.62:1841	69.251.1.62:
6	24.1.73.3:1774	24.1.73.3:
7	67.189.173.51:1035	67.189.173.51:
8	69.174.244.77:9050	69.174.244.77:
9	76.22.161.245:1868	76.22.161.245:
Sheet5

 

[shg]

Or find and replace :* with :

 

[Krishnakumar]

Hi,


Select Range > Hit Ctrl + H > Find what: ":*" (without quotes) > Replace with: ":" (without quotes)

HTH

 

[new2world]

thank you soo much guyz for helping me out in this .

 

[vba_newby]

you can also use text to columns and use : as the delimiter