Excel custom text format to align by first character when justified center or right

By default, a center-justified row with the Text format looks like:

enter image description here

I want the text to be center-justified in the cell and aligned by the first character, like:

enter image description here

Or

enter image description here

And if it is right-justified:

enter image description here

The solutions are fairly simple with formulas or VBA, but can these 3 formats be accomplished with custom formats? And with a variable number of characters?

formatting – Exapanding and Sympifying expression when using typesetting format

I’m starting to learn Mathematica, and in the book that I’m reading the author presented the commands “Simplify” and “Expand”. Now, the example in the book was the following:

Simplify((x^3 - y^3)/(x - y))

Now, this commend works, and outputs $x^2 + x y + y^2$. The problem is, if I use the
typesetting notation, the function doesn’t actually work:

Simplify($frac{x^3 – y^3}{x-y}$)

The above command outputs $frac{x^3 – y^3}{x-y}$, instead of the simplified form. The same happens for the command “Expand”.

Is there a way around this? As asked in the comment, here is the output of

Simplify($frac{x^3 – y^3}{x-y}$)FullForm

!(
TagBox(
StyleBox(
RowBox({"Times", "(", 
RowBox({
RowBox({"Power", "(", 
RowBox({
RowBox({"Plus", "(", 
RowBox({"x", ",", 
RowBox({"Times", "(", 
RowBox({
RowBox({"-", "1"}), ",", "y"}), ")"})}), ")"}), ",", 
RowBox({"-", "1"})}), ")"}), ",", 
RowBox({"Plus", "(", 
RowBox({"x\.b3", ",", 
RowBox({"Times", "(", 
RowBox({
RowBox({"-", "1"}), ",", "y\.b3"}), ")"})}), ")"})}), ")"}),
ShowSpecialCharacters->False,
ShowStringCharacters->True,
NumberMarks->True),
FullForm))

partitions – After doing a readback of my mediatek device in sp flash tool, why are some files in .bin format, others are in.img format, and others are blank?

After doing a readback of my mediatek device in sp flash tool, why are some files in .bin format, others are in.img format, and others are blank?

For e.g. the preloader is saved as .bin format, (as with logo.bin) and the boot/recovery/system partitions use .img

What format are the PGPT/ (partition tables) in? as they dont seem to have a file type?

Please see attached screenshot enter image description here

Is there a way in Google Sheets to automatically highlight the highest / lowest number in a range with a cell format colour?

Is there a way in Google Sheets to automatically highlight the highest / lowest number in a range with a cell format colour ?

Ive been trying using min() / max() and then build conditional formatting from the output of that, but it seems to have a quite a few moving parts, is there another more semantic way to do this ?

plugins – Add date format to a woocommerce custom field

Hi I have created a new delivery date checkout field using woocommerce field editor, now i cant use the date picker as the ajax pop i use to enter the shipping information doesnt support it, is there a way to set a format on the field like DD/MM/YYYY
Thanks

Webforms – Customise PDF format using entity print , Dompdf and PDF attachment field

I am using entity Print module and Dompdf as the PDF engine.
Added the PDF attachment field to my webform.Need to customise the PDF display using twig template.
Currently when I add my HTML = Twig variable View mode , the PDF does not show in the format.
Is there a way to add my custom HTML structure and display the PDF in desired style