Wednesday, January 09, 2008

Extracting data before and after the comma in excel

=TRIM(RIGHT(C1,LEN(C1)-SEARCH(",",C1)))
=TRIM(LEFT(C1,SEARCH(",",C1)-1))

No comments: