0

I have a table of different cell data that I want to insert into different hyperlinks for each item:

=HYPERLINK("https://www.otcmarkets.com/stock/CELL DATA TO BE INSERTED/security","SECURITY")

Cell data = four letter data below

KICK   Expected output: https://www.otcmarkets.com/stock/KICK/security

SCGX   Expected output: https://www.otcmarkets.com/stock/SCGX/security

RBTK

JCTG

HWGG

I am using Google Sheets. I do have Numbers, but not Excel. Can I do this?

0

=ARRAYFORMULA(IF(LEN(A1:A), 
 HYPERLINK("https://www.otcmarkets.com/stock/"&A1:A&"/security", "SECURITY"), ))

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.