Hi,i have encounter 2 problem now..could you provide me with some advise
or solution if possible..thanks

1)Trim doesn't seems to work cause when i put =trim(B3) into a blank
cell, there is still a blank space infront of the text..it is like the
same lo..how do you solve this?

2)I tried to use vlookup but it is like displaying me with an N/A thing
in the past but now when i type it in a formula bar..it doesn't show any
result as in it just display the formula i put in and no value..get
it??with be very grateful for that help..plenty of thanks


--
Seeking help
------------------------------------------------------------------------
Seeking help's Profile: http://www.excelforum.com/member.php...o&userid=35658
View this thread: http://www.excelforum.com/showthread...hreadid=572953