I have a column of data that has Property Codes & Property Codes_Area Codes
I need create a column that has just the property code, that is delete the _ and data after it.
The script below works for all that have an _ but doesn't bring across those that don't
Left (code,Index(code,'_')-1),code as Property_Code1,
How can I add to this, or is there another way, so that the column of info above ends up like below