Systems Automation
A Blog of Automation and Administration Activities
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
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment