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

Excel Subtract text after the third space and before the fourth (from between spaces) 3
Trim Characters Other Than An Empty Space At The End Of A Cell 5
How do I delete a space at the end of an amount or text 5
Space Before a Paragraph at the Start of a page 4
delete the extra space at the end of an entry 1
How to extract separated text by many commas in Excel? 0
remove tail spaces 2
Can I automatically have a space after the content in an Excel cel 2

Top