Neville Bentley
Board Regular
- Joined
- Oct 3, 2007
- Messages
- 101
Hi Out there,
I have a report, which I get from BW (SAP Reporting tool) when I export it to Excel I get a very annoying characteristic happening with in Excel. Because it is text, excel puts a character in front of the text so that it does not get formatted - that is the only thing I can think of.
If I use the "Text to Columns" function under the Data tab I get no joy.
Does anyone know how to get rid of this "Invisible" character so that I can do a VLOOKUP on it.
Here is an example: 'UK > Australia AF I need it to look like UK > Australia AF without the ' character.
Cheers
Neville
I have a report, which I get from BW (SAP Reporting tool) when I export it to Excel I get a very annoying characteristic happening with in Excel. Because it is text, excel puts a character in front of the text so that it does not get formatted - that is the only thing I can think of.
If I use the "Text to Columns" function under the Data tab I get no joy.
Does anyone know how to get rid of this "Invisible" character so that I can do a VLOOKUP on it.
Here is an example: 'UK > Australia AF I need it to look like UK > Australia AF without the ' character.
Cheers
Neville