Re: $$Excel-Macros$$ Query - How to make reversal string.

Dear Expert , Can you expline the bold line as i want to know deeply. Function Reverse(Text As String) As String Dim i As Integer Dim StrNew As String Dim strOld As String strOld = Trim(Text) For i = 1 To Len(strOld) * StrNew = Mid(strOld, i, 1) StrNew* Next i

Re: $$Excel-Macros$$ Query - How to make reversal string.

Hi, It is working fine. In Cell A3 data is 958321.1 which is reversed as 1.123859. Pl check confirm. Thanks!! On Mon, Jul 22, 2013 at 10:55 AM, Ashish Kumar kumar.ashish...@gmail.comwrote: Dear VbA, thanks for your help. but this formula is not working properly.

Re: $$Excel-Macros$$ Query - How to make reversal string.

Dear VBA, Thanks for your help and valuable support. this is woking fine. Thanks, Ashish On 22 July 2013 11:44, vba v...@vabs.in wrote: Hi, It is working fine. In Cell A3 data is 958321.1 which is reversed as 1.123859. Pl check confirm. Thanks!! On Mon, Jul 22,

Re: $$Excel-Macros$$ Query - How to make reversal string.

Dear Seniors, Thank to all of you. Your help means a lot for me. thanks. thanks, Ashish On Monday, July 22, 2013 11:44:56 AM UTC+5:30, Vabz wrote: Hi, It is working fine. In Cell A3 data is 958321.1 which is reversed as 1.123859. Pl check confirm. Thanks!!

Re: $$Excel-Macros$$ Query - How to make reversal string.

Respected Ashish, Simply use the attached add-in. On Mon, Jul 22, 2013 at 12:00 PM, Ashish Kumar kumar.ashish...@gmail.comwrote: Dear Seniors, Thank to all of you. Your help means a lot for me. thanks. thanks, Ashish On Monday, July 22, 2013 11:44:56 AM UTC+5:30, Vabz wrote:

Re: $$Excel-Macros$$ Query - How to make reversal string.

Sent: Monday, July 22, 2013 11:21 AM Subject: Re: $$Excel-Macros$$ Query - How to make reversal string. Dear Expert , Can you expline the bold line as i want to know deeply. Function Reverse(Text As String) As String     Dim i As Integer     Dim StrNew As String     Dim strOld As String

$$Excel-Macros$$ Query - How to make reversal string.

Dear Seniors, I have this type of data : 54321 ASDF 8796564 DFRESW But I want OUTPUT like below mentioned : 12345 FDSA 4656978 WSERFD How to make ti reversal through formula. Please help ?? Thanks Regards, Ashish Kumar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

Re: $$Excel-Macros$$ Query - How to make reversal string.

Dear Ashish sir, thanks for your quick response, but this is not working i want solve this query only from excel formula not VbA. coz, i want to reverse string in some columns not whole excel sheet. please suggest me how to resolve this query from excel formula. Thanks, Ashish On Sunday,

Re: $$Excel-Macros$$ Query - How to make reversal string.

Hi Ashish, Try this Function Reverse(Text As String) As String Dim i As Integer Dim StrNew As String Dim strOld As String strOld = Trim(Text) For i = 1 To Len(strOld) StrNew = Mid(strOld, i, 1) StrNew Next i Reverse = StrNew End Function

Re: $$Excel-Macros$$ Query - How to make reversal string.

Dear Vabs, Thanks for you reply, the formula is working but when I change this formula accordingly this is not working properly. please find attached excel sheet for query data. On 21 July 2013 21:20, vba v...@vabs.in wrote: Hey, Try this, this works up to 12 character.

Re: $$Excel-Macros$$ Query - How to make reversal string.

PFA Thanks On Sun, Jul 21, 2013 at 11:10 PM, Ashish Kumar kumar.ashish...@gmail.comwrote: Dear Vabs, Thanks for you reply, the formula is working but when I change this formula accordingly this is not working properly. please find attached excel sheet for query data. On 21 July 2013

Re: $$Excel-Macros$$ Query - How to make reversal string.

Dear VbA, thanks for your help. but this formula is not working properly. Thanks, Ashish On 22 July 2013 10:27, vba v...@vabs.in wrote: PFA Thanks On Sun, Jul 21, 2013 at 11:10 PM, Ashish Kumar kumar.ashish...@gmail.comwrote: Dear Vabs, Thanks for you reply, the formula is