Assign Formula to Variable
 

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

Assign Formula to Variable
 

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

Assign Formula to Variable
 

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

Assign Formula to Variable
 

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