removing characters
From: noobie6675 (noobie6675.175ecr_at_excelforum-nospam.com)
Date: 06/01/04
- Next message: Bennos: "Keyboard Shortcut for..."
- Previous message: Peo Sjoblom: "Re: Rounding up Time Values"
- Next in thread: Ed Ferrero: "Re: removing characters"
- Reply: Ed Ferrero: "Re: removing characters"
- Reply: Domenic: "Re: removing characters"
- Reply: Peo Sjoblom: "Re: removing characters"
- Messages sorted by: [ date ] [ thread ]
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/
- Next message: Bennos: "Keyboard Shortcut for..."
- Previous message: Peo Sjoblom: "Re: Rounding up Time Values"
- Next in thread: Ed Ferrero: "Re: removing characters"
- Reply: Ed Ferrero: "Re: removing characters"
- Reply: Domenic: "Re: removing characters"
- Reply: Peo Sjoblom: "Re: removing characters"
- Messages sorted by: [ date ] [ thread ]