17.1.8.=CELL("prefix", A1) returns the type of text alignment in a cell. |
|
A single quotation mark (') if the cell is left-aligned
|
|
A double quotation mark (") if the cell is right-aligned
|
|
A carat (^) if the cell is set to centered;
|
|
A backslash(\) if the cell is fill-aligned.
|
|
If the cell is blank or has a number, then the function returns nothing.
|
|
Input the formula: =CELL("prefix", A1). Press Enter to get the result.
|
|
|