get char position google sheet from right code example Example: left cell value sheets =INDIRECT(ADDRESS(ROW(),COLUMN()-1))