Re: removing characters

From: Peo Sjoblom (terre08_at_mvps.org)
Date: 06/01/04 

Date: Mon, 31 May 2004 22:43:56 -0400

You might also want to look at this if this is your problem

http://support.microsoft.com/default.aspx?scid=kb;[LN];214285

all on one line 

-- 
For everyone's benefit keep the discussion in the newsgroup.
Regards,
Peo Sjoblom
"noobie6675 >" <<noobie6675.175ecr@excelforum-nospam.com> wrote in message
news:noobie6675.175ecr@excelforum-nospam.com...
> Hi,
>
> I have an xls *** that i have outputted from a Access database.
>
> I find that one field that i need to work with has been given a "`" in
> front of it... ie instead of 3... it will have a `3
>
> now i need to do various mathematical equations on these fields and it
> wont let me do it while the ` is present.  As it is a extremely large
> spread*** 40 thousand +  i was wondering if there is a quick way to
> remove this character? ie get rid of first character?
>
> cheers
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>