Merging cells with text as one line
 

Below I have four cells with different text. C2 and E2 will never change, D2
will be a list option and F2 will be a manual entry. What formula can I
enter that will allow cells C2, D2, E2 and F2 to be shown in C7 as a
hyperlink? Thanks for the help.

C2 D2 E2 F2
http://www. Rabbit .com/order= 12345679

C7
Return the combination of all the above in this merged cell as a hyperlink

You can use the HYPERLINK function: =HYPERLINK(C2&D2&E2&F2)

Jim wrote:
Below I have four cells with different text. C2 and E2 will never change, D2
will be a list option and F2 will be a manual entry. What formula can I
enter that will allow cells C2, D2, E2 and F2 to be shown in C7 as a
hyperlink? Thanks for the help.

C2 D2 E2 F2
http://www. Rabbit .com/order= 12345679

C7
Return the combination of all the above in this merged cell as a hyperlink



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html