(Msg. 17) Posted: Fri Sep 05, 2008 3:03 am
Post subject: Re: cannot convert text string into value [Login to view extended thread Info.] Archived from groups: microsoft>public>excel>worksheet>functions (more info?)
My problem has been solved using the LEFT formula.
Thank you PETE, Ron, Don, Dave and David as well.
Andy
"Pete_UK" <pashurst DeleteThis @auditel.net>
???????:7bb4b710-2120-4927-92a0-e053f0513a57@y38g2000hsy.googlegroups.com...
Or you can use the LEFT formula I gave you this morning - change the 1
to a 2 if you have 2 of these "spaces", etc.
Pete
On Sep 1, 8:52 pm, "Andy" <Andy_1... DeleteThis @gamil.com> wrote:
> Your formula still doesn't work as I find there is a space at the
> rightmost
> of the string, how can I eliminate it by formula?
>
> thanks
>
> Andy
>
All times are: Eastern Time (US & Canada) (change) Goto page Previous1, 2, 3
Page 3 of 3
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office