| To extract the characters from a text string based on the no of character specify from left | |||
| Syntax | |||
| LEFT(text,num_chars) | |||
| B | C | D | |
| 8 | Names | First Name | Formula |
| 9 | Rajeev Sharma | Rajeev | =LEFT(B9,FIND(" ",B9)-1) |
| 10 | Rohit Bansal | Rohit | =LEFT(B10,FIND(" ",B10)-1) |
| 11 | Amit shrivastava | Amit | =LEFT(B11,FIND(" ",B11)-1) |
| Find function which is used with left finds the space and returns the position of space | |||
Wednesday, 10 August 2011
Left Function
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment