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
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
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