From: Amnon Wilensky on 22 Feb 2010 01:14 Hi, > How can I reverse, with Excel, the letters in a certain cell? For example; > I want Excel to rewrite > the word "black" as "kcalb" in cell A1?. > Using Excel 2003. > Thanks, > Amnon
From: macropod on 22 Feb 2010 03:07 Hi Amnon, See reply to your similar post in microsoft.public.word.conversions. For Excel, simply change the calling macro's code to: Sub ReverseString() Selection.Value = Reverse(Selection) End Sub -- Cheers macropod [Microsoft MVP - Word] "Amnon Wilensky" <wilensky(a)isdn.net.il> wrote in message news:OVexFZ4sKHA.3656(a)TK2MSFTNGP06.phx.gbl... > Hi, >> How can I reverse, with Excel, the letters in a certain cell? For example; >> I want Excel to rewrite >> the word "black" as "kcalb" in cell A1?. >> Using Excel 2003. >> Thanks, >> Amnon > > >
From: Gord Dibben on 22 Feb 2010 11:32 Public Function RevStr(rng As Range) RevStr = StrReverse(rng.text) End Function =RevStr(cell) Gord Dibben MS Excel MVP On Mon, 22 Feb 2010 08:14:16 +0200, "Amnon Wilensky" <wilensky(a)isdn.net.il> wrote: > Hi, >> How can I reverse, with Excel, the letters in a certain cell? For example; >> I want Excel to rewrite >> the word "black" as "kcalb" in cell A1?. >> Using Excel 2003. >> Thanks, >> Amnon > >
From: Amnon Wilensky on 23 Feb 2010 18:29 Hi, I have tried your suggestions without success, (probably my default). Enclosed a picture with what I have done, Where is my mistake? Thanks, Amnon "Amnon Wilensky" <wilensky(a)isdn.net.il> wrote in message news:OVexFZ4sKHA.3656(a)TK2MSFTNGP06.phx.gbl... > Hi, >> How can I reverse, with Excel, the letters in a certain cell? For example; >> I want Excel to rewrite >> the word "black" as "kcalb" in cell A1?. >> Using Excel 2003. >> Thanks, >> Amnon > > >
|
Pages: 1 Prev: How do I format cells in Excel to make 175/5 read 175? Next: Check Dynamic Named Range |