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 need to be a bit more
> "cre
On Tue, 2/21/17, Paul Schreiner wrote:
Subject: Re: $$Excel-Macros$$ to add - sign in vehical number
To: "excel-macros@googlegroups.com"
Date: Tuesday, February 21, 2017, 2:19 PM
Its
simple enough to determine the last 4 characters
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)&"-"&RIGHT(F3,4)
copy to all rows, then copy/paste Values to
