External material number with trailing spaces

[Former Member]

Hi ,

One of our users created a material number(external number range) by copying it from a spreadsheet. The value he copied had trailing spaces and when he copied it on to material number field the trailing spaces were not removed by SAP conversion routines . But when we deliberately type in trailing spaces the system removes them. Has anyone faced this kind of problems before? If so what is the solution.

Thanks,

Veera

[ja-ke · Accepted solution]

Hi,
Decided to reply to this oldie as I faced the exact same issue which to could not find a solution by googling. The issue lays in Excel itself. At least in Our case user had a symbol 'Zero Width Space' (200B) instead of 'Space' (0020). SAP then treats this 200B as an actual character and therefore the conversion routine doesn't kick in. You can change Your setup in Excel via 'Insert => Symbol'.

[Former Member]

Any Input??????