User Defined Function

[JohnAcc]

Hi There:

I need a udf to reverse the contents of a cell. i.e if cell A1 = Today then i need a udf to return yadot.

I can't seem to figure out how to write this code.

any ideas?

Rgds, John

 

[JohnAcc]

I think I've found my solution:

Function LtoR(Data)
Chars = Len(Data)
For i = Chars To 1 Step -1
Text = Text + Mid(Data, i, 1)
Next
LtoR = Text
End Function

I'm not sure if this is the most efficient way to do this but it works !

Rgds, John