Add additional info to multiple fields
Assuming fields are in column A.
In B1 enter ="www." & A1
Double-click on the B1 fill handle to increment down column B.
When/if happy, select Column B and copy.
EditPaste Special(in place)ValuesOKEsc.
Gord Dibben MS Excel MVP
On Fri, 27 Jan 2006 10:15:16 -0600, autobiz
wrote:
I have many fields that has part of a url in it Example: abcmotors.com
and I would like to add www. in front of it to make the field a correct
link. I have over 4,000 that I need to do this with. I would like do it
all automaticly? Instead of one at a time.
Thanks
Doug
|