how do I easily convert a single column of text (multiple rows si.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet with '000's of rows - the first column is text which in
fact is a URL - how do I convert them all into URL's without going through
them individually and double clicking each one?

PS this is urgent :->
 
I'd insert a new column A and do:

=hyperlink(b1)
(in A1 and drag down)

Or maybe:
=hyperlink("http://" & b1)
and drag down.

depends on what you really have in that cell.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert table to a single column 1
How to transfer values from one column to a big table? 3
How do I get rid of a series of hyperlinks in a column or row 4
How to insert row and column labels into a single cell 3
Multiple columns into single row 3
Cut and Paste Text with CRLF into Single Cell 1
Can I delete a portion of cell contents repeating in multiple fie. 1
Text to Rows 2

Back
Top