View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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.