Invisible space appearing in ell

[Airbiskit]

Hi,

I am trying to do a vlookup between 2 worksheets but the value is coming back as #N/A

The source worksheet supplying the data has a problem with the its pairing column. If I enter the cell at the rightside of the number and click the delete button the vlookup works.

Is there a quick way of correcting this?

Thanks

Steve

 

[Hasit]

not clear what you are doing. Could you explain the issue again pls, and perhaps provide the formula you are using that is causing the problem.

Also could you give an example of the structure and content of the data (dummy data will suffice).

 

[AnotherHiggins]

If I enter the cell at the rightside of the number and click the delete button the vlookup works.

So you have trailing spaces in the cells?

If so, have a look at the TRIM function. You can use a "helper column" with a formula like [COLOR=blue white]=trim(A2)[/color] and fill that down. Then Copy 'n' Paste Values over the original column, then delete the helper column.

If the only space in the cell is at the end, and if the character in the cell is really a space (and not some other non-printable character) then another route would be to use Text-To-Columns. Choose Space as a delimiter, then choose "Treat consecutive delimiters as one".

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.