I have an excel spreadsheet with a list of part numbers (text) and list of codes (text).

The codes are a 2 digit number for example: 13.

The problem is in the Oracle database (JDEdwards) the Code field is a 24 character string field, stored as 10-spaces followed by the 2-digit code, for example: "          13" with no trailing spaces.

I know I can enter the 10 space prefix in the excel file but I want to make it easy on other users to just load part numbers and codes into the excel file and run their crystal report without making them add blank spaces.

I did write numerous formulas using trim({field name}). That works, I just was looking for a way to link the fields.

I believe there is a LTrim for Oracle.  Thus when joining tables it would be something like this

Inner Join sometable on LTrim(sometable.field) = othertable.field

I am not sure what other string functions are available in Oracle.