Reverse a string

[BrianM]

Is there a function that can reverse the contents of a cell?

i.e. A1=Cat ...result = tac

Thanks,
Brian

 

[Todd Bardoni]

FYI on reverse funtion VBA:-

http://www.mrexcel.com/board2/viewtopic.php?p=357320#357320

there is also a Formula approach posted by Tushar in the same thread posted above (uses morefunc addin)

 

[erik.van.geit]

Hi, Domenic,

just tested it
works in Excel 2000

kind regards,
Erik

EDIT: I see Todd pointed to something useful, thank you, Todd

 

[DominicB]

Hi

Thanks for that Erik.

Todd, people should always do a quick search of the forum before posting their questions, shouldn't they...

Thanks guys

DominicB

 

[erik.van.geit]

Todd, people should always do a quick search of the forum before posting their questions, shouldn't they

yes, but some hours ago it took me 20 minutes to find only one post about Join and XL97 (join doesn't exist in XL97)
(using advanced google)
so you need some "luck" to get what you want