date:20130721

Re: $$Excel-Macros$$ group dates into months

2013-07-21 Thread Vabz

Hi

Pl refer. http://chandoo.org/wp/2009/11/17/group-dates-in-pivot-tables/

Thanks

On Friday, July 5, 2013 6:03:30 PM UTC+5:30, Krishnaraddi V. Madolli wrote:
>
>  Does anyone know how to group dates into months in a Pivot table in 
> Excel *2003*?
>
>  
>
> Regards,
>
> Krishnaraddi V Madolli.
>
>  
>  
> "CONFIDENTIALITY NOTICE: This message and any attachment are confidential 
> and may also be privileged. If you are not the intended recipient of this 
> e-mail you may not copy, forward, disclose or otherwise use it or any part 
> of it in any form whatsoever. If you are not the intended recipient please 
> telephone or e-mail the sender and delete this message and any attachment 
> from your system."
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ respuzy

2013-07-21 Thread Hilary Lomotey

http://dooncarryingcompany.com/ibeablao/zdukok.enfj

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ how are you?

2013-07-21 Thread Prasad Pai

 http://redwood-hotel.com/qvm/syfyvhrfeh



















 prasadpain











 7/21/2013 2:00:21 PM

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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

2013-07-21 Thread Ashish Kumar

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 wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Export Excel Data Into Outlook email template

2013-07-21 Thread ashish koul

hi

visit this link http://www.rondebruin.nl/win/s1/outlook/mail.htm

you will find multiple options for sending email automatically using macros



On Sat, Jul 20, 2013 at 6:54 PM, dynamitekicker wrote:

> Thanks Ashish! Word mail merge is a satisfactory solution, but ultimately
> I would still need to insert fields for the date and several other fields.
> I'm looking for something that is automated with a single click and
> requires essentially no editing before sending.
>
> Thanks again.
>
> On Saturday, July 20, 2013 4:32:10 AM UTC-4, ashish wrote:
>>
>> you can try word mail merge
>>
>>
>> On Sat, Jul 20, 2013 at 5:59 AM, dynamitekicker wrote:
>>
>>> Hi all,
>>>
>>> Hi all newbie over here attempting to learn macros. I am currently
>>> trying to convert information from an Excel document into an Outlook email
>>> template. I have attached an Excel file with representative data. When
>>> sending off a job summary I want to just be able to run a macro on a single
>>> row that has the ability to insert the various cell contents into an email
>>> (i.e. highlighted portions below). Is this possible? Are there any places I
>>> could go to get a better idea of this?
>>>
>>> *Contractors Name: *[INSERT CONTRACTOR NAME HERE]
>>>
>>> *Shipment Start Location:* [INSERT STARTING LOCATION HERE]
>>> *Departure Date: *[INSERT DEPARTURE DATE HERE]
>>>
>>> *Shipment End Location: *[INSERT DESTINATION HERE]
>>> *Arrival Date:* [INSERT ARRIVAL DATE HERE]
>>>
>>>
>>>  --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/**discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros...@**googlegroups.com.
>>> To post to this group, send email to excel-...@googlegroups.com.
>>> Visit this group at 
>>> http://groups.google.com/**group/excel-macros
>>> .
>>> For more options, visit 
>>> https://groups.google.com/**groups/opt_out
>>> .
>>>
>>>
>>>
>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>>
>>
>> *Visit*
>> *My Excel Blog *
>> Like Us on 
>> Facebook
>> Join Us on Facebook 
>>
>>
>> P Before printing, think about the environment.
>>
>>
>>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>



-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*My Excel Blog *
Like Us on 
Facebook
Join Us on Facebook 


P Before printing, think about the environment.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIM

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

2013-07-21 Thread Ashish Kumar

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, July 21, 2013 7:53:24 PM UTC+5:30, ashish wrote:
>
> 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
>>
>> 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 wanna be? It’s 
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>  
>> FORUM RULES
>>  
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>  
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
>> members are not responsible for any loss.
>> --- 
>> You received this message because you are subscribed to the Google Groups 
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to excel-macros...@googlegroups.com .
>> To post to this group, send email to excel-...@googlegroups.com
>> .
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>  
>>  
>>
>
>
>
> -- 
> *Regards*
> * *
> *Ashish Koul*
>
>
> *Visit*
> *My Excel Blog *
> Like Us on 
> Facebook
> Join Us on Facebook 
>
>
> P Before printing, think about the environment.
>
>  
>  

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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

2013-07-21 Thread vba

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,LEN(B1)-6,1))&
IF(LEN(B1)<8,"",MID(B1,LEN(B1)-7,1))&
IF(LEN(B1)<9,"",MID(B1,LEN(B1)-8,1))&
IF(LEN(B1)<10,"",MID(B1,LEN(B1)-9,1))&
IF(LEN(B1)<11,"",MID(B1,LEN(B1)-10,1))&
IF(LEN(B1)<12,"",MID(B1,LEN(B1)-11,1))

HTH//Cheers


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
>
> 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 wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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

2013-07-21 Thread ashish koul

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
>
> 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 wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>



-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*My Excel Blog *
Like Us on 
Facebook
Join Us on Facebook 


P Before printing, think about the environment.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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

2013-07-21 Thread xlstime

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


.

Enjoy
Team XLS



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
>
> 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 wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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

2013-07-21 Thread Ashish Kumar

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,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,LEN(B1)-6,1))&
> IF(LEN(B1)<8,"",MID(B1,LEN(B1)-7,1))&
> IF(LEN(B1)<9,"",MID(B1,LEN(B1)-8,1))&
> IF(LEN(B1)<10,"",MID(B1,LEN(B1)-9,1))&
> IF(LEN(B1)<11,"",MID(B1,LEN(B1)-10,1))&
> IF(LEN(B1)<12,"",MID(B1,LEN(B1)-11,1))
>
> HTH//Cheers
>
>
> 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
>>
>> 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 wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>>
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/excel-macros/B6GqW6OVGqQ/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.

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

2013-07-21 Thread vba

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:
>
>> 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,LEN(B1)-6,1))&
>> IF(LEN(B1)<8,"",MID(B1,LEN(B1)-7,1))&
>> IF(LEN(B1)<9,"",MID(B1,LEN(B1)-8,1))&
>> IF(LEN(B1)<10,"",MID(B1,LEN(B1)-9,1))&
>> IF(LEN(B1)<11,"",MID(B1,LEN(B1)-10,1))&
>> IF(LEN(B1)<12,"",MID(B1,LEN(B1)-11,1))
>>
>> HTH//Cheers
>>
>>
>>  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
>>>
>>> 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 wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>>
>>>
>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to a topic in the
>> Google Groups "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this topic, visit
>> https://groups.google.com/d/topic/excel-macros/B6GqW6OVGqQ/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To

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

2013-07-21 Thread Ashish Kumar

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
>> 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,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,LEN(B1)-6,1))&
>>> IF(LEN(B1)<8,"",MID(B1,LEN(B1)-7,1))&
>>> IF(LEN(B1)<9,"",MID(B1,LEN(B1)-8,1))&
>>> IF(LEN(B1)<10,"",MID(B1,LEN(B1)-9,1))&
>>> IF(LEN(B1)<11,"",MID(B1,LEN(B1)-10,1))&
>>> IF(LEN(B1)<12,"",MID(B1,LEN(B1)-11,1))
>>>
>>> HTH//Cheers
>>>
>>>
>>>  On Sun, Jul 21, 2013 at 7:51 PM, Ashish Kumar <
>>> kumar.ashish...@gmail.com> wrote:
>>>
  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 wanna be?
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners
 and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups "MS EXCEL AND VBA MACROS" group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.

 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.



>>>
>>>  --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to a topic in the
>>> Google Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this topic, visit
>>> https://groups.google.com/d/topic/excel-macros/B6GqW6OVGqQ/unsubscribe.
>>> To unsubscribe from this group and all its topics, send an email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>>
>>>
>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>>

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

2013-07-21 Thread Prafull Jadhav

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
Reverse = StrNew
End Function

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 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
>>> 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,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,LEN(B1)-6,1))&
 IF(LEN(B1)<8,"",MID(B1,LEN(B1)-7,1))&
 IF(LEN(B1)<9,"",MID(B1,LEN(B1)-8,1))&
 IF(LEN(B1)<10,"",MID(B1,LEN(B1)-9,1))&
 IF(LEN(B1)<11,"",MID(B1,LEN(B1)-10,1))&
 IF(LEN(B1)<12,"",MID(B1,LEN(B1)-11,1))

 HTH//Cheers


  On Sun, Jul 21, 2013 at 7:51 PM, Ashish Kumar <
 kumar.ashish...@gmail.com> wrote:

>  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 wanna be?
> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners
> and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google
> Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to excel-macros+unsubscr...@googlegroups.com.
>
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners
 and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to a topic in the
 Google Groups "MS EXCEL AND VBA MACROS" group.
 To unsubscribe from this topic, visit
 https://groups.google.com/d/topic/excel-macros/B6GqW6OVGqQ/unsubscribe.
 To unsubscribe from this group and all its topics, send an email to
 excel-macros+unsubscr...@googlegroups.com.

 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.



>>>
>>>  --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook

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

2013-07-21 Thread vba

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 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
>>> 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,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,LEN(B1)-6,1))&
 IF(LEN(B1)<8,"",MID(B1,LEN(B1)-7,1))&
 IF(LEN(B1)<9,"",MID(B1,LEN(B1)-8,1))&
 IF(LEN(B1)<10,"",MID(B1,LEN(B1)-9,1))&
 IF(LEN(B1)<11,"",MID(B1,LEN(B1)-10,1))&
 IF(LEN(B1)<12,"",MID(B1,LEN(B1)-11,1))

 HTH//Cheers


  On Sun, Jul 21, 2013 at 7:51 PM, Ashish Kumar <
 kumar.ashish...@gmail.com> wrote:

>  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 wanna be?
> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners
> and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google
> Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to excel-macros+unsubscr...@googlegroups.com.
>
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners
 and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to a topic in the
 Google Groups "MS EXCEL AND VBA MACROS" group.
 To unsubscribe from this topic, visit
 https://groups.google.com/d/topic/excel-macros/B6GqW6OVGqQ/unsubscribe.
 To unsubscribe from this group and all its topics, send an email to
 excel-macros+unsubscr...@googlegroups.com.

 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.



>>>
>>>  --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, For

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

2013-07-21 Thread Ashish Kumar

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 at 10:55 AM, Ashish Kumar 
> wrote:
>
>> 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 <
>>> kumar.ashish...@gmail.com> 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,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,LEN(B1)-6,1))&
> IF(LEN(B1)<8,"",MID(B1,LEN(B1)-7,1))&
> IF(LEN(B1)<9,"",MID(B1,LEN(B1)-8,1))&
> IF(LEN(B1)<10,"",MID(B1,LEN(B1)-9,1))&
> IF(LEN(B1)<11,"",MID(B1,LEN(B1)-10,1))&
> IF(LEN(B1)<12,"",MID(B1,LEN(B1)-11,1))
>
> HTH//Cheers
>
>
>  On Sun, Jul 21, 2013 at 7:51 PM, Ashish Kumar <
> kumar.ashish...@gmail.com> wrote:
>
>>  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 wanna be?
>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like
>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>> Advice will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>> and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google
>> Groups "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it,
>> send an email to excel-macros+unsubscr...@googlegroups.com.
>>
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners
> and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/excel-macros/B6GqW6OVGqQ/unsubscribe
> .
> To unsubscribe from this group and all its topics, send an email to
> excel-macros+unsubscr...@googlegroups.com.
>
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

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

2013-07-21 Thread Ashish Kumar

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!!
>
>
> 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 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 
 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,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,LEN(B1)-6,1))&
> IF(LEN(B1)<8,"",MID(B1,LEN(B1)-7,1))&
> IF(LEN(B1)<9,"",MID(B1,LEN(B1)-8,1))&
> IF(LEN(B1)<10,"",MID(B1,LEN(B1)-9,1))&
> IF(LEN(B1)<11,"",MID(B1,LEN(B1)-10,1))&
> IF(LEN(B1)<12,"",MID(B1,LEN(B1)-11,1))
>
> HTH//Cheers
>
>
>  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
>>
>> 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 wanna be? 
>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>  
>> FORUM RULES
>>  
>> 1) Use concise, accurate thread titles. Poor thread titles, like 
>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 
>> Advice will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>  
>> NOTE : Don't ever post confidential data in a workbook. Forum owners 
>> and members are not responsible for any loss.
>> --- 
>> You received this message because you are subscribed to the Google 
>> Groups "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, 
>> send an email to excel-macros...@googlegroups.com .
>>
>> To post to this group, send email to 
>> excel-...@googlegroups.com
>> .
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>  
>>  
>>
>
>  -- 
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? 
> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
> https://www.facebook.com/discussexcel
>  
> FORUM RULES
>  
> 1) Use concise, accurate thread titles. Poor thread titles, like 
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 
> Advice will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security 
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>  
> NOTE : Don't ever post confidential data in a workbook. Forum owners 
> and members are not responsible for any loss.
> --- 
> You received this message because you are subscribed to a topic in the 
> Google Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this topic, visit 
> https://groups.google.com/d/topic/excel-macros/B6GqW6OVGqQ/unsubscribe
> .
> To unsubscribe from this group and all its topics, send an email to 
> excel-macros...@googlegroups.com .
>
> To post to this group, send email to 
> excel-...@googlegroups.com
> .
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google

$$Excel-Macros$$ doubt with regard to change event of the combo

2013-07-21 Thread Shankar Bheema

Hai everyone

I attached an excel sheet which contains a form.  In that I placed three
nos. of combo boxes.  Each have its values.

when I change the gp combo value the remaining two combo values should
automatically change.

I tried in many ways but failed.

please help me out.

regards
shankar sb

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.




combo doubt.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ group dates into months

$$Excel-Macros$$ respuzy

$$Excel-Macros$$ how are you?

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

Re: $$Excel-Macros$$ Export Excel Data Into Outlook email template

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

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

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

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

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

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

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

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

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

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

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

$$Excel-Macros$$ doubt with regard to change event of the combo

17 matches

Site Navigation

Mail list logo

Footer information