Modifying text data in an imported contact file

[Stuff]

Hi,

(I am using Excel 2000)

I have imported close to 700 contacts from a web based contact manager. I
have successfully separated the first, middle, and last names using DATA >
COLUMNS-To-TEXT..

2 "problems" remain-- a serious one and a not-so-serious one:

#! --- The names are hyperlinked to the old web based URL, and selecting a
name brings up the website -- this is the serious problem -- how do I remove
the hyperlink leaving only text?

#2 --- The names are all capitalized -- not-so-serious, but not-so-nice --
how can I efficiently produce all lower-case letters following the initial
capital letter?

Thank you for you suggestions!!!!
"Howie"

--

"Before I end my letter, I pray Heaven to bestow
the best of Blessings on this House and all that shall
hereafter inhabit it. May none but honest and wise
Men ever rule under this roof."
John Adams, in a letter to Abigail,
on his 2nd night in the White House.

 

[Stuff]

I copy pasted the individual columns into Word (2000), selected TABLE >
SELECT > COLUMN, then used FORMAT > CHANGE CASE > SENTENCE, and
voila!!!!!!!!

 

[Stuff]

....cannot figure how to make the hyperlinked names plain text
!!!!!!!!!!!!!!!

 

[J.E. McGimpsey]

One way:

Type ALT-F11 to enter the Visual Basic Editor. In the Immediate
window (View/Immediate Window), type or paste

ActiveSheet.Hyperlinks.Delete

and hit Enter. Type ALT-F11 to return to XL.

 

[Stuff]

Than-Q, J.E. !!!!!!!!!!!!!!!!!!!!!!

One way:

Type ALT-F11 to enter the Visual Basic Editor. In the Immediate
window (View/Immediate Window), type or paste

ActiveSheet.Hyperlinks.Delete

and hit Enter. Type ALT-F11 to return to XL.