hi
i needed a macro for the following scenario

my input in excel sheet is as follows

suresh 9(9)

rajesh x(9)

ramesh +9(13)V99

vijay +9V9(8)

man xx

here x represents varchar,9 represents numeric


the out put should be

suresh numeric(9)

rajesh varchar(9)

ramesh numeric(15,2)

vijay numeric(9,8)

man varchar(2)


thanks in advance