Getting annoying space after numbers on vlookup

[DPChristman]

I have a unique situation.

I have a spreadsheet with over 1,200 logins to CCTV systems across the US.

I built a simple lookup file so that you can place the location number in and you will get the IP/ID address to copy and place into the third party CCTV monitoring system.

The formula works, but when I try to copy and paste the IP/ID number, it adds a space after the number.

The third party software does not recognize the space, so you can't login to the CCTV system.

I can just tell the users to back out the blank space, but is there a way to have the blank space not be there in first place?

 

[Fluff]

Duplicate to: Getting annoying space after numbers on vlookup

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.