Re: $$Excel-Macros$$ Need help to split numbers available in the last
=RIGHT(A2,LEN(A2)-LOOKUP(2^15,FIND( ,A2,ROW(INDIRECT(1:LEN(A2)) check this out Regards, Mandeep Baluja LearningZmyPassion https://www.linkedin.com/profile/view?id=312532939 https://www.facebook.com/VBAEXCELSQL?ref=hl On Thursday, August 6, 2015 at 8:53:47 AM UTC+5:30, Ashish_Bhalara wrote: Hi Nasir, Your message can not view but you can use below formula to split number. =--IFERROR(TRIM(RIGHT(A2,LEN(A2)-SEARCH( ,A2,1))),0) Regards Ashish Bhalara On Wed, Aug 5, 2015 at 5:11 PM, Nasir Shaikh nasir...@gmail.com javascript: wrote: KEY=1ad2be5fa4f57b86403816ac8682739e41b04832CLIENT=520b4539-6b10-73eb-2e6e-2728cff6aa79 This secure message was sent using Dmail. To view this message, simply click the button below View Message https://mail.delicious.com/view/?id=1ad2be5fa4f57b86403816ac8682739e41b04832key=520b4539-6b10-73eb-2e6e-2728cff6aa79 Secure message sent via Dmail https://mail.delicious.com https://mail.delicious.com On Wed, Aug 5, 2015 at 5:08 PM, Paul Schreiner schrein...@att.net javascript: wrote: Sorry, I am unable to view the response. *Paul* - *“Do all the good you can,By all the means you can,In all the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can.” - John Wesley* - -- *From:* Nasir Shaikh nasir...@gmail.com javascript: *To:* excel-...@googlegroups.com javascript: *Sent:* Wednesday, August 5, 2015 7:34 AM *Subject:* Re: $$Excel-Macros$$ Need help to split numbers available in the last KEY=55a65c4efb80535a8efd001eee190a4795a02accCLIENT=f090d7af-c960-0296-57db-a2d0ed8b4084 This secure message was sent using Dmail. To view this message, simply click the button below View Message https://mail.delicious.com/view/?id=55a65c4efb80535a8efd001eee190a4795a02acckey=f090d7af-c960-0296-57db-a2d0ed8b4084 Secure message sent via Dmail https://mail.delicious.com/ https://mail.delicious.com/ On Wed, Aug 5, 2015 at 4:54 PM, Paul Schreiner schrein...@att.net javascript: wrote: For MOST of the data, you could use an excel function like: =TRIM(RIGHT(TRIM(A3),15)) (for row 3) but rows 2 and 7 do not have the $$ at the end of the row. In fact, they do not seem to have the $$ at all! *Paul* - *“Do all the good you can,By all the means you can,In all the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can.” - John Wesley* - -- *From:* Paul Schreiner schrein...@att.net javascript: *To:* excel-...@googlegroups.com javascript: excel-...@googlegroups.com javascript: *Sent:* Wednesday, August 5, 2015 7:21 AM *Subject:* Re: $$Excel-Macros$$ Need help to split numbers available in the last What type of solution are you looking for? VBA macros? Excel function? Manual steps? how often do you need to do this? (is it a one-time thing, or daily/weekly/monthly?) What is the source of the data? Can you provide delimiters in the output? *Paul* - *“Do all the good you can,By all the means you can,In all the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can.” - John Wesley* - -- *From:* Nasir Saikh nasir...@gmail.com javascript: *To:* MS EXCEL AND VBA MACROS excel-...@googlegroups.com javascript: *Sent:* Wednesday, August 5, 2015 3:35 AM *Subject:* $$Excel-Macros$$ Need help to split numbers available in the last Hi, Please help me out to split numbers from a cells if the numbers available in the last then. Example attached. Thanks. -- 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
Re: $$Excel-Macros$$ Need help to split numbers available in the last
What type of solution are you looking for?VBA macros? Excel function?Manual steps? how often do you need to do this?(is it a one-time thing, or daily/weekly/monthly?) What is the source of the data?Can you provide delimiters in the output? Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Nasir Saikh nasirsa...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Wednesday, August 5, 2015 3:35 AM Subject: $$Excel-Macros$$ Need help to split numbers available in the last Hi, Please help me out to split numbers from a cells if the numbers available in the last then. Example attached. Thanks. -- 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/d/optout. -- 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/d/optout.
Re: $$Excel-Macros$$ Need help to split numbers available in the last
For MOST of the data, you could use an excel function like: =TRIM(RIGHT(TRIM(A3),15)) (for row 3) but rows 2 and 7 do not have the $$ at the end of the row.In fact, they do not seem to have the $$ at all! Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Paul Schreiner schreiner_p...@att.net To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Wednesday, August 5, 2015 7:21 AM Subject: Re: $$Excel-Macros$$ Need help to split numbers available in the last What type of solution are you looking for?VBA macros? Excel function?Manual steps? how often do you need to do this?(is it a one-time thing, or daily/weekly/monthly?) What is the source of the data?Can you provide delimiters in the output? Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Nasir Saikh nasirsa...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Wednesday, August 5, 2015 3:35 AM Subject: $$Excel-Macros$$ Need help to split numbers available in the last Hi, Please help me out to split numbers from a cells if the numbers available in the last then. Example attached. Thanks. -- 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/d/optout. -- 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/d/optout. -- 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
Re: $$Excel-Macros$$ Need help to split numbers available in the last
KEY=55a65c4efb80535a8efd001eee190a4795a02accCLIENT=f090d7af-c960-0296-57db-a2d0ed8b4084 This secure message was sent using Dmail. To view this message, simply click the button below View Message https://mail.delicious.com/view/?id=55a65c4efb80535a8efd001eee190a4795a02acckey=f090d7af-c960-0296-57db-a2d0ed8b4084 Secure message sent via Dmail https://mail.delicious.com https://mail.delicious.com On Wed, Aug 5, 2015 at 4:54 PM, Paul Schreiner schreiner_p...@att.net wrote: For MOST of the data, you could use an excel function like: =TRIM(RIGHT(TRIM(A3),15)) (for row 3) but rows 2 and 7 do not have the $$ at the end of the row. In fact, they do not seem to have the $$ at all! *Paul* - *“Do all the good you can,By all the means you can,In all the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can.” - John Wesley* - -- *From:* Paul Schreiner schreiner_p...@att.net *To:* excel-macros@googlegroups.com excel-macros@googlegroups.com *Sent:* Wednesday, August 5, 2015 7:21 AM *Subject:* Re: $$Excel-Macros$$ Need help to split numbers available in the last What type of solution are you looking for? VBA macros? Excel function? Manual steps? how often do you need to do this? (is it a one-time thing, or daily/weekly/monthly?) What is the source of the data? Can you provide delimiters in the output? *Paul* - *“Do all the good you can,By all the means you can,In all the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can.” - John Wesley* - -- *From:* Nasir Saikh nasirsa...@gmail.com *To:* MS EXCEL AND VBA MACROS excel-macros@googlegroups.com *Sent:* Wednesday, August 5, 2015 3:35 AM *Subject:* $$Excel-Macros$$ Need help to split numbers available in the last Hi, Please help me out to split numbers from a cells if the numbers available in the last then. Example attached. Thanks. -- 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/d/optout. -- 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/d/optout. -- 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
Re: $$Excel-Macros$$ Need help to split numbers available in the last
Actually, I originally used:=TRIM(RIGHT(TRIM(A3),10)) it worked for all except row 2 and 7 but then I noticed it didn't work for row 15.(it was only off by 3,000,000. No big deal, right?) So I ASSUMED I could just change 10 characters to 15 and be good. But I was wrong.It seems the TRIM() function in excel works differently than the trim() function in VBA.in VBA, it only removes the spaces at the beginning and end of the string.In Excel, it seems to also remove any DUPLICATE spaces within the string. There is no Excel function equivalent to VBA's RTRIM() function. I'll have to look at an alternative. Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Paul Schreiner schreiner_p...@att.net To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Wednesday, August 5, 2015 7:24 AM Subject: Re: $$Excel-Macros$$ Need help to split numbers available in the last For MOST of the data, you could use an excel function like: =TRIM(RIGHT(TRIM(A3),15)) (for row 3) but rows 2 and 7 do not have the $$ at the end of the row.In fact, they do not seem to have the $$ at all! Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Paul Schreiner schreiner_p...@att.net To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Wednesday, August 5, 2015 7:21 AM Subject: Re: $$Excel-Macros$$ Need help to split numbers available in the last What type of solution are you looking for?VBA macros? Excel function?Manual steps? how often do you need to do this?(is it a one-time thing, or daily/weekly/monthly?) What is the source of the data?Can you provide delimiters in the output? Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Nasir Saikh nasirsa...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Wednesday, August 5, 2015 3:35 AM Subject: $$Excel-Macros$$ Need help to split numbers available in the last Hi, Please help me out to split numbers from a cells if the numbers available in the last then. Example attached. Thanks. -- 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/d/optout. -- 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
Re: $$Excel-Macros$$ Need help to split numbers available in the last
Sorry, I am unable to view the response. Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Nasir Shaikh nasirsa...@gmail.com To: excel-macros@googlegroups.com Sent: Wednesday, August 5, 2015 7:34 AM Subject: Re: $$Excel-Macros$$ Need help to split numbers available in the last KEY=55a65c4efb80535a8efd001eee190a4795a02accCLIENT=f090d7af-c960-0296-57db-a2d0ed8b4084 This secure message was sent using Dmail. To view this message, simply click the button below | View Message | | Secure message sent via Dmail | On Wed, Aug 5, 2015 at 4:54 PM, Paul Schreiner schreiner_p...@att.net wrote: For MOST of the data, you could use an excel function like: =TRIM(RIGHT(TRIM(A3),15)) (for row 3) but rows 2 and 7 do not have the $$ at the end of the row.In fact, they do not seem to have the $$ at all! Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Paul Schreiner schreiner_p...@att.net To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Wednesday, August 5, 2015 7:21 AM Subject: Re: $$Excel-Macros$$ Need help to split numbers available in the last What type of solution are you looking for?VBA macros? Excel function?Manual steps? how often do you need to do this?(is it a one-time thing, or daily/weekly/monthly?) What is the source of the data?Can you provide delimiters in the output? Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Nasir Saikh nasirsa...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Wednesday, August 5, 2015 3:35 AM Subject: $$Excel-Macros$$ Need help to split numbers available in the last Hi, Please help me out to split numbers from a cells if the numbers available in the last then. Example attached. Thanks. -- 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/d/optout. -- 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/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT
Re: $$Excel-Macros$$ Need help to split numbers available in the last
KEY=1ad2be5fa4f57b86403816ac8682739e41b04832CLIENT=520b4539-6b10-73eb-2e6e-2728cff6aa79 This secure message was sent using Dmail. To view this message, simply click the button below View Message https://mail.delicious.com/view/?id=1ad2be5fa4f57b86403816ac8682739e41b04832key=520b4539-6b10-73eb-2e6e-2728cff6aa79 Secure message sent via Dmail https://mail.delicious.com https://mail.delicious.com On Wed, Aug 5, 2015 at 5:08 PM, Paul Schreiner schreiner_p...@att.net wrote: Sorry, I am unable to view the response. *Paul* - *“Do all the good you can,By all the means you can,In all the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can.” - John Wesley* - -- *From:* Nasir Shaikh nasirsa...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Wednesday, August 5, 2015 7:34 AM *Subject:* Re: $$Excel-Macros$$ Need help to split numbers available in the last KEY=55a65c4efb80535a8efd001eee190a4795a02accCLIENT=f090d7af-c960-0296-57db-a2d0ed8b4084 This secure message was sent using Dmail. To view this message, simply click the button below View Message https://mail.delicious.com/view/?id=55a65c4efb80535a8efd001eee190a4795a02acckey=f090d7af-c960-0296-57db-a2d0ed8b4084 Secure message sent via Dmail https://mail.delicious.com/ https://mail.delicious.com/ On Wed, Aug 5, 2015 at 4:54 PM, Paul Schreiner schreiner_p...@att.net wrote: For MOST of the data, you could use an excel function like: =TRIM(RIGHT(TRIM(A3),15)) (for row 3) but rows 2 and 7 do not have the $$ at the end of the row. In fact, they do not seem to have the $$ at all! *Paul* - *“Do all the good you can,By all the means you can,In all the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can.” - John Wesley* - -- *From:* Paul Schreiner schreiner_p...@att.net *To:* excel-macros@googlegroups.com excel-macros@googlegroups.com *Sent:* Wednesday, August 5, 2015 7:21 AM *Subject:* Re: $$Excel-Macros$$ Need help to split numbers available in the last What type of solution are you looking for? VBA macros? Excel function? Manual steps? how often do you need to do this? (is it a one-time thing, or daily/weekly/monthly?) What is the source of the data? Can you provide delimiters in the output? *Paul* - *“Do all the good you can,By all the means you can,In all the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can.” - John Wesley* - -- *From:* Nasir Saikh nasirsa...@gmail.com *To:* MS EXCEL AND VBA MACROS excel-macros@googlegroups.com *Sent:* Wednesday, August 5, 2015 3:35 AM *Subject:* $$Excel-Macros$$ Need help to split numbers available in the last Hi, Please help me out to split numbers from a cells if the numbers available in the last then. Example attached. Thanks. -- 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/d/optout. -- 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
Re: $$Excel-Macros$$ Need help to split numbers available in the last
Hi Nasir, Your message can not view but you can use below formula to split number. =--IFERROR(TRIM(RIGHT(A2,LEN(A2)-SEARCH( ,A2,1))),0) Regards Ashish Bhalara On Wed, Aug 5, 2015 at 5:11 PM, Nasir Shaikh nasirsa...@gmail.com wrote: KEY=1ad2be5fa4f57b86403816ac8682739e41b04832CLIENT=520b4539-6b10-73eb-2e6e-2728cff6aa79 This secure message was sent using Dmail. To view this message, simply click the button below View Message https://mail.delicious.com/view/?id=1ad2be5fa4f57b86403816ac8682739e41b04832key=520b4539-6b10-73eb-2e6e-2728cff6aa79 Secure message sent via Dmail https://mail.delicious.com https://mail.delicious.com On Wed, Aug 5, 2015 at 5:08 PM, Paul Schreiner schreiner_p...@att.net wrote: Sorry, I am unable to view the response. *Paul* - *“Do all the good you can,By all the means you can,In all the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can.” - John Wesley* - -- *From:* Nasir Shaikh nasirsa...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Wednesday, August 5, 2015 7:34 AM *Subject:* Re: $$Excel-Macros$$ Need help to split numbers available in the last KEY=55a65c4efb80535a8efd001eee190a4795a02accCLIENT=f090d7af-c960-0296-57db-a2d0ed8b4084 This secure message was sent using Dmail. To view this message, simply click the button below View Message https://mail.delicious.com/view/?id=55a65c4efb80535a8efd001eee190a4795a02acckey=f090d7af-c960-0296-57db-a2d0ed8b4084 Secure message sent via Dmail https://mail.delicious.com/ https://mail.delicious.com/ On Wed, Aug 5, 2015 at 4:54 PM, Paul Schreiner schreiner_p...@att.net wrote: For MOST of the data, you could use an excel function like: =TRIM(RIGHT(TRIM(A3),15)) (for row 3) but rows 2 and 7 do not have the $$ at the end of the row. In fact, they do not seem to have the $$ at all! *Paul* - *“Do all the good you can,By all the means you can,In all the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can.” - John Wesley* - -- *From:* Paul Schreiner schreiner_p...@att.net *To:* excel-macros@googlegroups.com excel-macros@googlegroups.com *Sent:* Wednesday, August 5, 2015 7:21 AM *Subject:* Re: $$Excel-Macros$$ Need help to split numbers available in the last What type of solution are you looking for? VBA macros? Excel function? Manual steps? how often do you need to do this? (is it a one-time thing, or daily/weekly/monthly?) What is the source of the data? Can you provide delimiters in the output? *Paul* - *“Do all the good you can,By all the means you can,In all the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can.” - John Wesley* - -- *From:* Nasir Saikh nasirsa...@gmail.com *To:* MS EXCEL AND VBA MACROS excel-macros@googlegroups.com *Sent:* Wednesday, August 5, 2015 3:35 AM *Subject:* $$Excel-Macros$$ Need help to split numbers available in the last Hi, Please help me out to split numbers from a cells if the numbers available in the last then. Example attached. Thanks. -- 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/d/optout. -- 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