=HYPERLINK("mailto:"&ROW(F1)&"mailtest@mail.com.au",ROW(F1)&"mailtest@mail.com.au")
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
TRUSTED BY
are you trying to copy down those email addresses out? copy down and then ... ?
do you want to combine values such as A2&" "&B2 , etc ?