Vlookyp fails due to space at the end

E

Elton Law

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Space at end of multi page list to accommodate new entries 1
remove tail spaces 2
Removing spaces at the end of numbers 5
Can I automatically have a space after the content in an Excel cel 2
Copy formula amongst files but create cross-link problem 2
Paste from Web Paragraph Spacing 2
Spaces after Em dash (Longer dash) 7
If statement with Vlookup - including ISNA function to compare two columns from different worksheets 4

Top