Barney Evans
asked on
Excel 2007 Change case in a url in a column
Hi All,
I have a large Excel spreadsheet with URL's to be imported into my web server. I need to change just the display text of the URL's to upper case.
Example
From: <a href="//ctparts.com/catalo gsearch/re sult/?q=ct 0201csf" alt="ct0201csf">ct0201csf< /a>
To: <a href="//ctparts.com/catalo gsearch/re sult/?q=ct 0201csf" alt="ct0201csf">CT0201CSF< /a>
Can I do this easily with a formula in a new column?
Thanks!
I have a large Excel spreadsheet with URL's to be imported into my web server. I need to change just the display text of the URL's to upper case.
Example
From: <a href="//ctparts.com/catalo
To: <a href="//ctparts.com/catalo
Can I do this easily with a formula in a new column?
Thanks!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER