I have a column of data that has Property Codes & Property Codes_Area Codes
3ALB272
3ALBERO7
3ALBER7A
3CAR16/2A
3BRAD5_BR2
3MANN2A_BR3
3MOZ3
3CP3-18
3MIT117_BR12
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
3ALB272
3ALBERO7
3ALBER7A
3CAR16/2A
3BRAD5
3MANN2A
3MOZ3
3CP3-18
3MIT117
