I recently received a .csv file which Numbers opened ok. In that .csv file were cells with url's that Numbers must have determined as text. How can I format a column of cells and format that to be hyperlinks?
MacBook Air, macOS High Sierra (10.13)
Do you have Smartlinks checked at Edit > Substutions in your menu?
If all the links have come is text you can use the HYPERLINK function. If the text is in, for example, column B row 2 and down you can add a column C with this formula in C2,
=(HYPERLINK(B2)
and fill it down the column.
The links in column C will be live.
SG
Do you have Smartlinks checked at Edit > Substutions in your menu?
If all the links have come is text you can use the HYPERLINK function. If the text is in, for example, column B row 2 and down you can add a column C with this formula in C2,
=(HYPERLINK(B2)
and fill it down the column.
The links in column C will be live.
SG
Thanks. As it turns out, they were links but I did not recognize them as such until I clicked on one. Went to the site. So my bad...but your good information.
How do I hyperlink?
