Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
trim and vlookup dun work
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
trim and vlookup dun work
Hi Seeking Help,
1) The intial space may in fact be a non-breaking space character. See David McRitchie's TrimAll sub at: http://www.mvps.org/dmcritchie/excel/join.htm - trimall 2) Perhaps the cell in question is formatted as text, Change the format and try re-entering your formula. Alternatively, check that the display formulas option is not selected: Tools | View | Window Options | Formulas --- Regards, Norman "Seeking help" wrote in message news:Seeking.help.2cq1hn_1155880503.2428@excelforu m-nospam.com... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trim does not work | Excel Programming | |||
Trim Function... does not work? | Excel Programming | |||
using trim cmd. When I type this command it does not work. When I. | Excel Worksheet Functions | |||
Trim function won't work in VBA | Excel Programming | |||
Trim function in Excel Doesn't work for certain cells | Excel Programming |