removing characters

From: noobie6675 (noobie6675.175ecr_at_excelforum-nospam.com)
Date: 06/01/04


Date: Mon, 31 May 2004 20:25:41 -0500

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/