Looking for UDF for this formula

[Alex20850]

While it is simple formula that I could just copy down, but I am interested in user-defined formulas so how would a UDF be written for this?

=f10&""&e10

 

[Fluff]

How about

Function alex(C1 As Range, C2 As Range, Optional Delim As String = "") As String
   alex = C2 & Delim & C1
End Function

and used like
=alex(E10,F10)
or to use a different delimiter
=alex(E10,F10,", ")

 

[Alex20850]

Thanks for the code, but it doesn't look like code for my use.

 

[Fluff]

Apologies, copied the wrong stuff

I've corrected it & put the right code in there.

 

[Alex20850]

Thanks, works great. Easy to understand.

 

[Fluff]

You're welcome & thanks for the feedback