Excel - Enter URLs in the text format



Upon entering a URL (copy/paste) in Excel, the latter is automatically converted into a clickable hyperlink.
If you want to add the URL in the text format simply precede it by apostrophe (') sign. For example:
  • 'http://ccm.net
  • Note that: The apostrophe (') sign won't be displayed!
Published by deri58. Latest update on February 22, 2013 at 03:57 PM by deri58.
This document, titled "Excel - Enter URLs in the text format," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (https://ccm.net/).
Excel has encountered a problem and need to close!
Excel - Convert a row into a column and vice-versa