We help IT Professionals succeed at work.

Excel 2007 Change case in a url in a column

113 Views
Last Modified: 2017-03-22
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/catalogsearch/result/?q=ct0201csf" alt="ct0201csf">ct0201csf</a>
To: <a href="//ctparts.com/catalogsearch/result/?q=ct0201csf" alt="ct0201csf">CT0201CSF</a>

Can I do this easily with a formula in a new column?

Thanks!
Comment
Watch Question

CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
Excel & VBA Expert
CERTIFIED EXPERT
Most Valuable Expert 2018
Awarded 2015
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
Barney EvansIT System Administrator

Author

Commented:
Thanks! Works great!