Get rid of space at end of text so vlookup work

[sobrien1234]

I am trying to do a vlookup however the text in A1 has a space at the end of it whereas the vlookup text does not. Is there a formula to get rid of the space at the end of the text in A1 that I could write into B1?

Thanks!!

 

[mse330]

Yes, you can use

=TRIM(A1)

 

[Legacy 143009]

Infact yes,

There are two options but I would suggest to use first option which is more secure:

1. Add a helper column next to your data and wrap your data with TRIM() function and and use this column in your VLOOKUP().

2. Way may mislead you if the data similar to eachother. Use wildcards"*" in your VLOOKUP() function:

=VLOOKUP("*"& A1 &"*",A2:B3,2,FALSE)

 

[sobrien1234]

Yes, you can use

=TRIM(A1)

Perfect!! Thank you!!

 

[mse330]

Glad to help & thanks for reporting back