i have data cells that look similiar to this:
- Jack Nap
- Steve Lee
and excel replaces those text with #NAME? (invalid error name). im
assuming its doing this because of the - sign in front of the name. is
there a way i can force excel to ignore the error and show the text?
thanks in advance.
--
spr1nt
------------------------------------------------------------------------
spr1nt's Profile:
http://www.excelforum.com/member.php...o&userid=33528
View this thread:
http://www.excelforum.com/showthread...hreadid=533212