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 ), "-" )
--
Regards,
Luc.

"Festina Lente"


"hshayh0rn" wrote:

I have a cell that contains data that needs to be broken up among a few
different cells. The source cell contains data like:

COMPANYADDRESS2 VARCHAR2(35)

I need to put 35 in one cell and then VARCHAR in another. So I need a
worksheet function that finds the number between ( and ) and then I need
another function that figures out the characters between ( and the first
space to the left of the V in varchar2. Varchar2 is just an example of what
the data could be. Other examples could be number, date, etc...