www.dtptools.com
PRODUCTS HELP SUPPORT CONTACTS STORE ABOUT

host logoInDesign/InCopy

host logoiOS

host logoOnline Services

LEFT

LEFT function returns the first character(s) in a text source.

 

Example:

 

 
South Wales
Sothebys
Formula Result
=LEFT(A1,5)First five characters in the A1 cell text = South
=LEFT(A2)First character in the A2 cell text = S
     
© 2004 - 2021 DTP Tools Ltd. All rights reserved. Legal Notices. Disclaimer.