Excel Core Book
Get our FREE guide on Excel when you subscribe to our free newsletter
Fetch specified number of characters starting from the left of mentioned text string
Syntax of Excel Left formula:
=LEFT(text,[num_char]) will result in othe
=From left(of this text, fetch these many characters)
=LEFT(“other world of our own”,4) will result in othe
=LEFT(“A B C D”,3) will return “A B”. This is because space is also considered as character.