Assuming source data in A1 down

Try in say, B1:
=IF(A1="","",IF(ISNUMBER(FIND("#N/A N.A.",A1)),"----",A1))
Copy down
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"jolly79_ph" wrote
in message ...

Its a computer generated linked in futures contract table price: low,
high, close, previous, i encounter this #N/A N.A., in low and high, but
it's normal there is no figure on low & high column price sometimes, but
instead of #N/A N.A., i wanted to replace with "----", to make
appropriate to look, which means, the low and high price data is not
available. I hope this is clear for you.


--
jolly79_ph
------------------------------------------------------------------------
jolly79_ph's Profile:
http://www.excelforum.com/member.php...fo&userid=4835
View this thread: http://www.excelforum.com/showthread...hreadid=499652