| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Excel, using line wrap with text, some cells will appear as ##. | Excel Discussion (Misc queries) | |||
| how do i add the same text after current text in multiple cells | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| Why text to columns is not available when there is mulipule line . | Excel Worksheet Functions | |||
| Adding a text label to a line. | Charts and Charting in Excel | |||
Linear Mode
