PakAccountants.com

LEFT

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

In words:
=From left(of this text, fetch these many characters)

Examples of Excel Left fomula

=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.