Help with Creating a Function

[jpfulton]

I'm trying to figure out how to turn the following into a function:

=IF(AND(G2<>"",F2<>""),CONCATENATE(F2,"; ",G2),CONCATENATE(F2,G2))

Rather than referencing G2 and F2 I'd like the function to automatically reference the cell two to the left and one to the left respectively. Any help is appreciated!

 

[Fluff]

How about

Function jpfulton() As String
   Dim Cl As Range
   Application.Volatile
   Set Cl = Range(Application.Caller.Address)
   jpfulton = Cl.Offset(, -1) & "; " & Cl.Offset(, -2)
   If Cl.Offset(, -1) = "" Or Cl.Offset(, -2) = "" Then
      jpfulton = Replace(jpfulton, "; ", "")
   End If
End Function

 

[jpfulton]

I made one tiny tweak and it's perfect (it was concatenating the fields in the wrong order). Thank you!!

 

[Fluff]

You're welcome & thanks for the feedback