Lookup column gives "#" symbol when export to spreadsheet

Issue:

There are 3 lookup columns, when I export this list to spreadsheet these lookup fields export with #;ID attached to them, and I got "testdata#;15"  instead of "testdata" I get

Resolution:

It was resolved after unmarking check-box for "Allow Multiple Values" for that lookup column under column settings