$$Excel-Macros$$ Amount conversion from number to word
Dear experts, I need your help to convert amount in number to the word. For example, I prepared invice of amount $653.50 then it should convert to word as six hundred fifty three and 50/100 only. Please help. Thanks and best regards, Mehtab -- 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$$ Amount conversion from number to word
also try these links http://support.microsoft.com/kb/213360 http://blog.contextures.com/archives/2009/03/24/convert-number-to-words-in-excel/ http://www.ozgrid.com/VBA/CurrencyToWords.htm http://www.ozgrid.com/VBA/ValueToWords.htm http://excelvbaandmacros.blogspot.in/2011/12/excel-convert-amount-in-words.html On Sat, Aug 31, 2013 at 11:36 AM, mehtab shaikh meetmeh...@gmail.comwrote: Dear experts, I need your help to convert amount in number to the word. For example, I prepared invice of amount $653.50 then it should convert to word as six hundred fifty three and 50/100 only. Please help. Thanks and best regards, Mehtab -- 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 http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ 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. Number to words.xlsm Description: Binary data
$$Excel-Macros$$ Formulae for Removing Certain Word from Sentance
Dear Experts, Please find enclosed example sheet and kindly advice formulae how to remove certain words from sentence. Best Regards, Mehtab -- 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. EXAMPLE.xlsx Description: Binary data
Re: $$Excel-Macros$$ Formulae for Removing Certain Word from Sentance
=SUBSTITUTE(SUBSTITUTE(A1,Rupees,),PAISAS,) see if it helps On Sat, Aug 31, 2013 at 12:59 PM, mehtab shaikh meetmeh...@gmail.comwrote: Dear Experts, Please find enclosed example sheet and kindly advice formulae how to remove certain words from sentence. Best Regards, Mehtab -- 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 http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ 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.
$$Excel-Macros$$ Calculate break time Production time after removing break time
Hi Group, I have been trying to calculate the actual production time with certain conditions to it . Attached is the sample sheet with an example and conditions. -- Regards Santosh santoshkumar.subu...@gmail.com -- 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. Book2.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Interactive Dashboards
Hello All, Not sure if this has been discussed here before, also went through some other forums on googlegroups without any help. I am looking for Interactive Dashboard templates along with some tutorials on how to go about modifying or customizing them. Need it majorly to show region wise sales, revenues, resource utilization and things like that Hope this forum is of help !.. Regards, Priyanka Sachedva -- 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$$ Interactive Dashboards
Hi try these links see if it helps http://chandoo.org/wp/2010/01/04/sales-dashboards/ http://chandoo.org/wp/2008/03/28/73-free-designer-quality-excel-chart-templates-grab-now-and-become-a-charting-superman/ http://chandoo.org/wp/2011/03/22/customer-service-dashboard/ http://www.excelhero.com/blog/2010/09/animated-business-chart-3.html http://chandoo.org/wp/2012/07/30/excel-salary-survey-contest-results/ http://www.facebook.com/EXCELVBAMACROS http://www.clearlyandsimply.com/clearly_and_simply/2009/06/choropleth-maps-with-excel.html Regards Ashish On Sat, Aug 31, 2013 at 8:14 PM, Priyanka Sachdeva priyanka.sachdeva...@gmail.com wrote: Hello All, Not sure if this has been discussed here before, also went through some other forums on googlegroups without any help. I am looking for Interactive Dashboard templates along with some tutorials on how to go about modifying or customizing them. Need it majorly to show region wise sales, revenues, resource utilization and things like that Hope this forum is of help !.. Regards, Priyanka Sachedva -- 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 http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ 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$$ Interactive Dashboards
That was quick !!!..Thanks a lot ..will check out the links On Saturday, August 31, 2013 8:19:24 PM UTC+5:30, ashish wrote: Hi try these links see if it helps http://chandoo.org/wp/2010/01/04/sales-dashboards/ http://chandoo.org/wp/2008/03/28/73-free-designer-quality-excel-chart-templates-grab-now-and-become-a-charting-superman/ http://chandoo.org/wp/2011/03/22/customer-service-dashboard/ http://www.excelhero.com/blog/2010/09/animated-business-chart-3.html http://chandoo.org/wp/2012/07/30/excel-salary-survey-contest-results/ http://www.facebook.com/EXCELVBAMACROS http://www.clearlyandsimply.com/clearly_and_simply/2009/06/choropleth-maps-with-excel.html Regards Ashish On Sat, Aug 31, 2013 at 8:14 PM, Priyanka Sachdeva priyanka.s...@gmail.com javascript: wrote: Hello All, Not sure if this has been discussed here before, also went through some other forums on googlegroups without any help. I am looking for Interactive Dashboard templates along with some tutorials on how to go about modifying or customizing them. Need it majorly to show region wise sales, revenues, resource utilization and things like that Hope this forum is of help !.. Regards, Priyanka Sachedva -- 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 javascript:. To post to this group, send email to excel-...@googlegroups.comjavascript: . 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 http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ 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$$ Interactive Dashboards
The Sales Dashboard totally works for me !!!..pretty interesting stuff..Thanks a lot for this help again Regards, On Saturday, August 31, 2013 8:19:24 PM UTC+5:30, ashish wrote: Hi try these links see if it helps http://chandoo.org/wp/2010/01/04/sales-dashboards/ http://chandoo.org/wp/2008/03/28/73-free-designer-quality-excel-chart-templates-grab-now-and-become-a-charting-superman/ http://chandoo.org/wp/2011/03/22/customer-service-dashboard/ http://www.excelhero.com/blog/2010/09/animated-business-chart-3.html http://chandoo.org/wp/2012/07/30/excel-salary-survey-contest-results/ http://www.facebook.com/EXCELVBAMACROS http://www.clearlyandsimply.com/clearly_and_simply/2009/06/choropleth-maps-with-excel.html Regards Ashish On Sat, Aug 31, 2013 at 8:14 PM, Priyanka Sachdeva priyanka.s...@gmail.com javascript: wrote: Hello All, Not sure if this has been discussed here before, also went through some other forums on googlegroups without any help. I am looking for Interactive Dashboard templates along with some tutorials on how to go about modifying or customizing them. Need it majorly to show region wise sales, revenues, resource utilization and things like that Hope this forum is of help !.. Regards, Priyanka Sachedva -- 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 javascript:. To post to this group, send email to excel-...@googlegroups.comjavascript: . 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 http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ 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.
$$Excel-Macros$$ Fwd: Microsoft Excel Re: vlook up button for single click
-- Forwarded message -- From: veeru che1indi...@gmail.com Date: Fri, Aug 30, 2013 at 8:15 PM Subject: Microsoft Excel Re: vlook up button for single click To: microsoft-office-2...@googlegroups.com no one solved my problem? On Monday, August 19, 2013 12:40:44 PM UTC+5:30, veeru wrote: Sir, i am working in Mobile shop i logged the details in 1 excel sheet which received problems from customer i attached a excel sheet in first sheet i mentioned some our repair shop and service center in 2nd sheet log details ( daily many more entry ) i print N Column (service center address and paste to mobile box and send ) ex: i used column F ref service ccode 502-55-453-7501 vlookup formula i column N through first sheet Sir, is it possible to use a button to vlookup formula for single click pls make my work easy thanks -- You received this message because you are subscribed to the Google Groups Microsoft Excel Group - One stop solution for all your excel Problems group. To unsubscribe from this group and stop receiving emails from it, send an email to microsoft-office-2007+unsubscr...@googlegroups.com. To post to this group, send email to microsoft-office-2...@googlegroups.com. Visit this group at http://groups.google.com/group/microsoft-office-2007. 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.
$$Excel-Macros$$ Re: Query on Text to Columns function
Thanks Lalit for the solution, though the solution to my query is quite simpler..while using text to column on the very next step choose text for each column within text to column window. Regards Pooja Sharma Sent from my iPad On Aug 29, 2013, at 2:09 PM, Lalit Mohan Pandey mohan.pande...@gmail.com wrote: Try this Option Explicit Sub SplitValues() Dim lngLoop As Long Dim vararrRawData() As Variant Dim vararrSplitData As Variant 'Const variable change accordingly as per your requirement Const strDataRangeToSplit As String = C1:C65536 Const strDataShtNameAs String = Sheet1 Const strDataOutputShtName As String = Sheet1 Const strDataOutputCell As String = J1 With ThisWorkbook With .Worksheets(strDataShtName) vararrRawData = .Range(strDataRangeToSplit).Value End With With .Worksheets(strDataOutputShtName) For lngLoop = LBound(vararrRawData) To UBound(vararrRawData) .Range(strDataOutputCell).Offset(lngLoop - 1, 0).Value = vararrRawData(lngLoop, 1) vararrSplitData = Split(Replace(vararrRawData(lngLoop, 1), ., .'), .) If UBound(vararrSplitData) = 0 Then vararrSplitData(0) = vbNullString End If .Range(strDataOutputCell).Offset(lngLoop - 1, 1).Resize(, UBound(vararrSplitData) + 1).Value = vararrSplitData Next lngLoop End With End With lngLoop = Empty Erase vararrRawData vararrSplitData = Empty End Sub On Thursday, 29 August 2013 13:32:17 UTC+5:30, Pooja wrote: Hi All, Please advice on the below query. Regards Pooja Sharma Sent from BlackBerry® on Airtel From: Pooja Sharma pooja@dc.ibm.com Date: Thu, 29 Aug 2013 13:19:08 +0530 To: vatspo...@gmail.com Subject: Query on Text to Columns function Hi All, I am seeking for your support on one of my file (attached), wherein I have to separate the values in different columns, the separator (Delimitor) value is the . sign. I was trying to do this with the function text to columns, but it removes the zero value and I need these 0 values too. Please advice. -- 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$$ Re: Query on Text to Columns function
Try this code Sub Macro1() Dim Data As Range Application.DisplayAlerts = False Set Data = Range(C2, Range(C2).End(xlDown).Address) Data.TextToColumns Data.Offset(, 1), OtherChar:=., FieldInfo:=Array(Array(1, 2), Array(2, 2), Array(3, 2)) Application.DisplayAlerts = True End Sub On 01-09-2013 1:45, PoojaSharma wrote: Thanks Lalit for the solution, though the solution to my query is quite simpler..while using text to column on the very next step choose text for each column within text to column window. Regards Pooja Sharma Sent from my iPad On Aug 29, 2013, at 2:09 PM, Lalit Mohan Pandey mohan.pande...@gmail.com mailto:mohan.pande...@gmail.com wrote: Try this Option Explicit Sub SplitValues() Dim lngLoop As Long Dim vararrRawData() As Variant Dim vararrSplitData As Variant 'Const variable change accordingly as per your requirement Const strDataRangeToSplit As String = C1:C65536 Const strDataShtNameAs String = Sheet1 Const strDataOutputShtName As String = Sheet1 Const strDataOutputCell As String = J1 With ThisWorkbook With .Worksheets(strDataShtName) vararrRawData = .Range(strDataRangeToSplit).Value End With With .Worksheets(strDataOutputShtName) For lngLoop = LBound(vararrRawData) To UBound(vararrRawData) .Range(strDataOutputCell).Offset(lngLoop - 1, 0).Value = vararrRawData(lngLoop, 1) vararrSplitData = Split(Replace(vararrRawData(lngLoop, 1), ., .'), .) If UBound(vararrSplitData) = 0 Then vararrSplitData(0) = vbNullString End If .Range(strDataOutputCell).Offset(lngLoop - 1, 1).Resize(, UBound(vararrSplitData) + 1).Value = vararrSplitData Next lngLoop End With End With lngLoop = Empty Erase vararrRawData vararrSplitData = Empty End Sub On Thursday, 29 August 2013 13:32:17 UTC+5:30, Pooja wrote: Hi All, Please advice on the below query. Regards Pooja Sharma Sent from BlackBerry® on Airtel *From: * Pooja Sharma pooja@dc.ibm.com javascript: *Date: *Thu, 29 Aug 2013 13:19:08 +0530 *To: *vatspo...@gmail.com javascript: *Subject: *Query on Text to Columns function Hi All, I am seeking for your support on one of my file (attached), wherein I have to separate the values in different columns, the separator (Delimitor) value is the . sign. I was trying to do this with the function text to columns, but it removes the zero value and I need these 0 values too. Please advice. -- 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,