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 ...