Vlookyp fails due to space at the end
 

Dear Expert,
I need to vlookup following items and match the fields ...
Basically, this task is easy and straightforward.
However, system generated file will give unnecessary space at the end.
That is "Exotic Package OTC ". Number oif space is
irregular for each cell.
That's it ... System adds a lot of space after the text and finally makes
vlookup fails.
How can I remove the unnecessary space after the last alphabet of each cell
please?
Text to column ... try before but cant.
Replace " " (Space) with blank .... try before but cant ... because it
becomes ExoticPackageOTC (one word), then vlookup cannot make it again.
What function can screen out the unnecessary space after the last alphabets
please?
Thanks ...

Vlookyp fails due to space at the end
 

How about trying TRIM to clean it up?
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"Elton Law" wrote:
I need to vlookup following items and match the fields ...
Basically, this task is easy and straightforward.
However, system generated file will give unnecessary space at the end.
That is "Exotic Package OTC ". Number oif space is
irregular for each cell.
That's it ... System adds a lot of space after the text and finally makes
vlookup fails.
How can I remove the unnecessary space after the last alphabet of each cell
please?
Text to column ... try before but cant.
Replace " " (Space) with blank .... try before but cant ... because it
becomes ExoticPackageOTC (one word), then vlookup cannot make it again.
What function can screen out the unnecessary space after the last alphabets
please?
Thanks ...

Vlookyp fails due to space at the end
 

trim will definitly do te trick

"Elton Law" wrote:

Dear Expert,
I need to vlookup following items and match the fields ...
Basically, this task is easy and straightforward.
However, system generated file will give unnecessary space at the end.
That is "Exotic Package OTC ". Number oif space is
irregular for each cell.
That's it ... System adds a lot of space after the text and finally makes
vlookup fails.
How can I remove the unnecessary space after the last alphabet of each cell
please?
Text to column ... try before but cant.
Replace " " (Space) with blank .... try before but cant ... because it
becomes ExoticPackageOTC (one word), then vlookup cannot make it again.
What function can screen out the unnecessary space after the last alphabets
please?
Thanks ...