Aug 18 2020 05:15 PM
Aug 18 2020 09:17 PM - edited Aug 18 2020 09:40 PM
@Jbisca Well, the LEFT function takes the first character if no number of characters is specified. when you do specify a number (e.g. 1 or 2 or 3) it takes either the first, the first two or the first three characters. It can not take the first for one cell and, for instance the first three in another.
If your Excel version supports the SEQUENCE function, perhaps the attached solution offers an acceptable work-around.