Is there a way to remove all cell padding?

Hello!

I have this situation:

Fixed B column width: 90
A1= User enters text.
B1= Row. Autofits using VBA.

The formula in B1 is ="my"&A1.

There is a certain length of text that the user can type where when the autofit works, it adds an additional hrt (char(10)) with no text on it. If the text length is slightly shorter, you don't get that hrt.

I don't want to keep changing the column width to accomodate the longer text in A1. I just want it to do the word-wrap without Excel deciding "the text length is within my cell's padding so I need to add a hrt."

Is there a way to specifiy that I want no padding for a range of cells, and if the cell is going to hit the wall then wrap the text?

(I attached a file to illustrate what I am talking about.)

I appreciate any help with this!

VR/Lost