On Mon, 11 Dec 2006 10:13:01 -0800, PapaDos
wrote:

Assuming your data is in A1

=IF( ISNUMBER( FIND( "VARCHAR2", A1 ) ), "VARCHAR2", RIGHT( TRIM( A1 ), LEN(
TRIM( A1 ) ) - FIND( " ", TRIM( A1 ) ) ) )

=IF( ISNUMBER( FIND( "VARCHAR2", A1 ) ), MID( A1, FIND( "(", A1 ) + 1, FIND(
")", A1 ) - FIND( "(", A1 ) - 1 ), "-" )


Doesn't seem to work if there is a <space in COMPANYADDRESS and there is
noting in parenthesis following the number (which OP wrote was possible):

COMPANY ADDRESS2 2/5/06

I don't know if spaces are possible in COMPANYADDRESS however.





--ron