Showing posts with label Excel. Show all posts
Showing posts with label Excel. Show all posts

Tuesday, April 06, 2010

Thursday, February 04, 2010

Extracting Left side of Coma Sperated String

Here is the formula with eg

A1 = Ullas,Thachudayakaimal

=LEFT(A1,FIND(",",A1,1)-1)

The result is

Ullas