removing word for column

[gautam.bakshi]

Hi everyone,

I think i have a simple question but am not too famlair with excel
programing. I have a column full of fields like: "Website:
www.abc.com"

Is there a macro or something i can run to remove, for example, the
word Website:, so the fields will only read www.abc.com

Thanks in advance.

 

[Tom Ogilvy]

Select all the cells on the sheet or only a single cell and do
Edit=>Replace
what: Website: <include the space>
With: < leave blank">

click replace all

Turn on the macro recorder while you do it manually if you need a macro.

 

[gautam.bakshi]

wow, I feel so stupid.

Thanks for the solution.