Hi All, =LEN(A1)+1-FIND(CHAR(1),SUBSTITUTE(A1," ",CHAR(1),LEN(TRIM(A1))- > LEN(SUBSTITUTE(A1," ",""))))
The above formula works for me. Thanks a lot for all your efforts in helping me to solve this issue. On Sat, Jul 3, 2010 at 8:44 AM, ju...@thepepeshow.com <jmora...@gmail.com> wrote: > Dave, I think Praveen was looking for the count from right to left. > Your example formula results with 17 not 8. However, building on your > formula, you can simply subtract from the length of the cell. Here is > counting from right to left: > > =LEN(A1)+1-FIND(CHAR(1),SUBSTITUTE(A1," ",CHAR(1),LEN(TRIM(A1))- > LEN(SUBSTITUTE(A1," ","")))) > > Praveen, let us know what works for you. > > On Jul 2, 4:37 pm, Dave Bonallack <davebonall...@hotmail.com> wrote: >> Hi Praveen, >> It's a bit long-winded, but here's a formula to find the position of the >> last space in Cell A1: >> >> =FIND(CHAR(1),SUBSTITUTE(A1," ",CHAR(1),LEN(TRIM(A1))-LEN(SUBSTITUTE(A1," >> ","")))) >> >> Regards - Dave. >> >> >> >> > Date: Fri, 2 Jul 2010 19:48:01 +0530 >> > Subject: $$Excel-Macros$$ Fwd: >> > From: bhspra...@gmail.com >> > To: excel-macros@googlegroups.com >> >> > Hi Friends, >> >> > Is there any way to find the position of the space in a word from right >> > side. >> >> > Ex: United States of America - here the position of the space from >> > right side is 8. >> >> > -- >> >> > Regards, >> > praveen >> >> > -- >> > ---------------------------------------------------------------------------------- >> > Some important links for excel users: >> > 1. Follow us on TWITTER for tips tricks and links >> > :http://twitter.com/exceldailytip >> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 >> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com >> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com >> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com >> >> > To post to this group, send email to excel-macros@googlegroups.com >> >> > <><><><><><><><><><><><><><><><><><><><><><> >> > HELP US GROW !! >> >> > We reach over 7000 subscribers worldwide and receive many nice notes about >> > the learning and support from the group.Let friends and co-workers know >> > they can subscribe to group >> > athttp://groups.google.com/group/excel-macros/subscribe >> >> _________________________________________________________________ >> New, Used, Demo, Dealer or Private? Find it at >> CarPoint.com.auhttp://clk.atdmt.com/NMN/go/206222968/direct/01/ > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- Regards, praveen -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe