=TRIM(RIGHT(C1,LEN(C1)-SEARCH(",",C1)))
=TRIM(LEFT(C1,SEARCH(",",C1)-1))
Wednesday, January 09, 2008
Extracting data before and after the comma in excel
Add to:
digg
reddit
del.icio.us
Subscribe to:
Post Comments (Atom)
=TRIM(RIGHT(C1,LEN(C1)-SEARCH(",",C1)))
=TRIM(LEFT(C1,SEARCH(",",C1)-1))
Add to:
digg
reddit
del.icio.us
0 comments:
Post a Comment