CODEWITHSUNDEEP
stringexcelwidthvba
user3588043
user3588043

Reputation: 136

Excel VBA string WIDTH

In excel string length not equal to string size same length string with diff characters (spaces) looks shorter each other.

So then I trying to align two columns in drop down list I get result as in picture below in cell HAVE I need to do like in cell NEED

enter image description here

So how to get string width but not length?

Upvotes: 1

Views: 1805

Answers (1)

avb
avb

Reputation: 1753

Use monospace font (courier, consolas, lucida console etc).
This will do.

Upvotes: 2

Related Questions