Excel in alignment-CodePudding

I want to consult everybody, the excel table, A column is the original phonetic B column stress into red, C column is my way of Spaces by adding the accent aligned from top to bottom, I want to consult everybody can put stress alignment by means of formula function like C column,

CodePudding user response:

 C=space (15 - instr (A, "")) + A

CodePudding user response:

reference 1st floor zhao4zhong1 response:

 C=space (15 - instr (A, "")) + A

You can align like that?

Know what call "wider font" don't!

CodePudding user response:

refer to the second floor Chen8013 response:

Quote: refer to 1st floor zhao4zhong1 response:

C=space (15 - instr (A, "")) + A

You can align like that?

Know what call "wider font" don't!

To switch to monospaced font,

CodePudding user response:

reference zhao4zhong1 reply: 3/f

Quote: refer to the second floor Chen8013 response:

Quote: refer to 1st floor zhao4zhong1 response:

C=space (15 - instr (A, "")) + A

You can align like that?

Know what call "wider font" don't!

Switch to monospaced font,

What can you do a monospaced font "phonetic word stock for the original poster?

CodePudding user response:

reference 4 floor Chen8013 response:

Quote: reference zhao4zhong1 reply: 3/f
Quote: refer to the second floor Chen8013 response:

Quote: refer to 1st floor zhao4zhong1 response:

C=space (15 - instr (A, "")) + A

You can align like that?

Know what call "wider font" don't!

Switch to monospaced font,
What can you do a monospaced font "phonetic word stock for the original poster?

It is difficult?
Search "EUDC"

CodePudding user response:

reference 5 floor zhao4zhong1 reply:

Quote: refer to 4th floor Chen8013 response:

.
What can you do a monospaced font "phonetic word stock for the original poster?

It is difficult?
Search "EUDC"

After you put the word stock ready to say!

CodePudding user response:

refer to 6th floor Chen8013 response:

Quote: refer to the fifth floor zhao4zhong1 reply:

Quote: refer to 4th floor Chen8013 response:

.
What can you do a monospaced font "phonetic word stock for the original poster?

It is difficult?
Search "EUDC"

After you put the word stock ready to say!

To enough money I would do,

CodePudding user response:

https://www.baidu.com/s? Wd=% 20 international phonetic alphabet font width

CodePudding user response:

refer to 7th floor zhao4zhong1 response:

Quote: refer to the sixth floor Chen8013 response:

.

After you put the word stock ready to say!

To enough money I would do,

You go to find the landlord for money!

CodePudding user response:

to the bureau count!

CodePudding user response:

GetTextExtentPoint32
The GetTextExtentPoint32 function computes The width and height of The specified string of text.

BOOL GetTextExtentPoint32 (
HDC HDC,//handle to the device context
LPCTSTR lpString,//a pointer to the text string
Int cbString,//the number of characters in the string
LPSIZE LPSIZE//pointer to structure for the string size
);

The Parameters
HDC
Handle to the device context.
LpString
Pointer to the string of text. The string does not need to be zero - terminated, since cbString specifies the length of the string.
CbString
Specifies the number of characters in the string.
LpSize
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull