The worksheet named CharMap includes columns of numbers and symbols to can be used anywhere you see the word “CHAR.” The numbers that could be used in “char cell” are in columns A, D, G, J, M, and P. The resulting characters are displayed to the right of the “char numbers.”
What is CHAR?
CHAR is a formula, specifically CHAR(). The parenthesis contains a character number or in the case of how I am using CHAR, it contains a cell reference. Which numbers create which characters is OS (operating system) reliant and that is why I included the CharMap worksheet.
CHAR in the V Planner
Here is a list of worksheets and parts of the V Planner that include CHAR
- The C Planners (C1, C2, C3, C4)
- AU – in V Planner V4 and High School V Planner
- AUD in V Planner V4 – Cell D1 and is triggered by placing a “pipe” in cell A1.
- The Class Location List – The CharList for the locations may be edited at the Lists worksheet. see About the Location List
Some Characters do not Display All the Time
This is a mystery to me, but I have noticed that sometimes characters 1-8, 11, and 14-27 do not show up, but instead the numbers create a narrow box shape instead of the expected character. I’ve written this information of the CharMap worksheet, so you’ve been informed and there is not need to write me.
Why I Included CHAR – Line Breaks
Even though the numbers for CHAR() are OS reliant and therefore slightly unpredictable, I included the formula in some parts of the V Planner so that a line break could occur. Number 10 seems to consistently create a line break in Windows computers. I don’t know this by experience because I don’t have a Mac, but I’ve read that the number 13 creates a line break in Mac computers.
Below is a screen shot of CharMap worksheet as of V4 planners – If the image is compressed and un-viewable, then click on this link to view the image