Prev: How do I format cells in Excel to make 175/5 read 175?
Next: Check Dynamic Named Range
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