Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
removing word for column
wow, I feel so stupid.
Thanks for the solution. :-) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting a text column to a number column & removing the ' | Excel Worksheet Functions | |||
Removing watermarks in Word | Excel Discussion (Misc queries) | |||
Finding Info from Column A and Removing it from Column B | Excel Discussion (Misc queries) | |||
Removing a word | Excel Worksheet Functions | |||
removing the word (blank) from pivot table cells | Excel Discussion (Misc queries) |