removing word for column
 

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.

removing word for column
 

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.

--
Regards,
Tom Ogilvy


wrote in message
oups.com...
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.

removing word for column
 

wow, I feel so stupid.

Thanks for the solution. :-)