View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
spr1nt
 
Posts: n/a
Default Ignorning #NAME? error


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