I am sure this is simple but I can't figure our where I am going wrong, here is what I have

Length = Len(" & FileNumber4 & "

I am trying to assign to the variable named "Length" the number of characters in the variable named "FileNumber4

Where am I going wrong, I have looked around and I though this should work but the value for Length should end up as either a 5 or a 6 and it is telling me it is 17. I am a little lost

Thanks for the advice

Jim

James,

Try this

Length = Len(FileNumber4)


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"James Stephens" wrote in message
...
I am sure this is simple but I can't figure our where I am going wrong,
here is what I have.

Length = Len(" & FileNumber4 & ")

I am trying to assign to the variable named "Length" the number of
characters in the variable named "FileNumber4"

Where am I going wrong, I have looked around and I though this should work
but the value for Length should end up as either a 5 or a 6 and it is
telling me it is 17. I am a little lost.

Thanks for the advice,

Jim

Everything enclosed within a pair of double quotes is considered a
literal. So, you are getting the length of the literal string space-
ampersand-space-the-letters-that-spell-FileNumber4-space-ampersand-
space.

To get the length of the contents of FileNumber4 use Len(FileNumber4)

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I am sure this is simple but I can't figure our where I am going wrong, here is what I have.

Length = Len(" & FileNumber4 & ")

I am trying to assign to the variable named "Length" the number of characters in the variable named "FileNumber4"

Where am I going wrong, I have looked around and I though this should work but the value for Length should end up as either a 5 or a 6 and it is telling me it is 17. I am a little lost.

Thanks for the advice,

Jim

Thanks guys, that took care of it. Sometimes its so simple you just can't figure it out

Thanks alot for the help

Ji

----- Tushar Mehta wrote: ----

Everything enclosed within a pair of double quotes is considered a
literal. So, you are getting the length of the literal string space
ampersand-space-the-letters-that-spell-FileNumber4-space-ampersand
space

To get the length of the contents of FileNumber4 use Len(FileNumber4

--
Regards

Tushar Meht
www.tushar-mehta.co
Excel, PowerPoint, and VBA add-ins, tutorial
Custom MS Office productivity solution

In article ,
says..
I am sure this is simple but I can't figure our where I am going wrong, here is what I have
Length = Len(" & FileNumber4 & "
I am trying to assign to the variable named "Length" the number of characters in the variable named "FileNumber4
Where am I going wrong, I have looked around and I though this should work but the value for Length should end up as either a 5 or a 6 and it is telling me it is 17. I am a little lost
Thanks for the advice
Ji