Re: $$Excel-Macros$$ to add - sign in vehical number

2017-02-21 Thread jignesh audichya
thank so much for help me now its easy for me, once again thanks a lot. On Tue, Feb 21, 2017 at 5:49 PM, Paul Schreiner wrote: > Its simple enough to determine the last 4 characters using the right() > function. > But because the length varies (from 7 to 11), you

Re: $$Excel-Macros$$ to add - sign in vehical number

2017-02-21 Thread hopkinsruben865 via MS EXCEL AND VBA MACROS
On Tue, 2/21/17, Paul Schreiner <schreiner_p...@att.net> wrote: Subject: Re: $$Excel-Macros$$ to add - sign in vehical number To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com> Date: Tuesday, February 21

Re: $$Excel-Macros$$ to add - sign in vehical number

2017-02-21 Thread Paul Schreiner
Its simple enough to determine the last 4 characters using the right() function.But because the length varies (from 7 to 11), you need to be a bit more "creative" with the left() function. try inserting a column with:=LEFT(F3,LEN(F3)-4)&"-"(F3,4) copy to all rows, then copy/paste Values to