, 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
strOld = Trim(Text
Respected Ashish,
Simply use the attached add-in.
On Mon, Jul 22, 2013 at 12:00 PM, Ashish Kumar wrote:
> 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,
>>
>> I
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.
>
> T
Dear VBA,
Thanks for your help and valuable support. this is woking fine.
Thanks,
Ashish
On 22 July 2013 11:44, vba 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, 2013
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 wrote:
> Dear VbA,
>
> thanks for your help. but this formula is not working properly.
>
>
> Thanks,
> Ashish
>
>
> On
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
R
Dear VbA,
thanks for your help. but this formula is not working properly.
Thanks,
Ashish
On 22 July 2013 10:27, vba wrote:
> PFA
>
> Thanks
>
>
> On Sun, Jul 21, 2013 at 11:10 PM, Ashish Kumar
> wrote:
>
>> Dear Vabs,
>>
>> Thanks for you reply, the formula is working but when I change this
PFA
Thanks
On Sun, Jul 21, 2013 at 11:10 PM, Ashish Kumar wrote:
> 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 wrote:
>
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 wrote:
> Hey,
>
> Try this, this works up to 12 character.
>
> =IF(LEN(B1)<1,"",MID(B1,LE
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
.
try this udf
Function revr(s As String)
revr = StrReverse(s)
End Function
On Sun, Jul 21, 2013 at 7:51 PM, Ashish Kumar wrote:
> Dear Seniors,
>
> I have this type of data :
>
> 54321
> ASDF
> 8796564
> DFRESW
>
> But I want OUTPUT like below mentioned :
>
> 12345
> FDSA
> 4656978
> WSERFD
Hey,
Try this, this works up to 12 character.
=IF(LEN(B1)<1,"",MID(B1,LEN(B1),1))&
IF(LEN(B1)<2,"",MID(B1,LEN(B1)-1,1))&
IF(LEN(B1)<3,"",MID(B1,LEN(B1)-2,1))&
IF(LEN(B1)<4,"",MID(B1,LEN(B1)-3,1))&
IF(LEN(B1)<5,"",MID(B1,LEN(B1)-4,1))&
IF(LEN(B1)<6,"",MID(B1,LEN(B1)-5,1))&
IF(LEN(B1)<7,"",MID(B1,L
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, J
13 matches
Mail list logo
