The only way aside from the two methods you've mentioned (re-sizing the cell and setting it to wrap) is to have text in the adjacent cell. [edit: There's one other method I forgot, as Siddharth Rout pointed out, if you format cells as "Shrink to fit" (under alignment>text control), the font size will automatically shrink such that the content fits inside the cell width.] If you just want long text to get cut off at the cell's edge, Excel will do this only if the cell the text would otherwise flow into has content of its own.

The fastest way to enforce this automatically would be to:


Loop over all cells with content.
Place a blank space in the horizontally adjacent cells if they do not already have content.


Note that you should either do this to both cells to the left and right of cells with overflowing content, or check whether the text is left aligned or right aligned to help decide which of the two horizontally adjacent cells will need to be filled.

If you ONLY want to do this for cells that would have otherwise overflowed, then you have to do something more complicated. You will have to:


Loop over all cells with content.
Check if the cell adjacent to the current one is blank. If not, you can skip this cell and move on to the next one.
Copy the content of the current cell to cell in a blank column (preferably on a new temporary sheet).
Tell your temporary column to auto-size (to find out the desired width of the cell).
If the auto-size width of the temporary column is larger than the source column's width, then the cell content is going to overflow - so you need to place a blank space in the adjacent cell.


Prevent Cell Overlap in Excel using VBA
I need to apply successive interference cancellation (SIC) to an RF signal which is the result of collisions between 2 or more unsynchronised packets. For this question let's just assume that the number of packets is 2.

In SIC, you store the collided packets until one of the packets are repeated and use the 'clean' packet to extract the other packet from the collided data.

My question is, what techniques can be used to extract an unknown packet from a collision between that packet and a known packet?

How do you deal with the packet sources not being synchronised?

Going through the possible tags for this question, it seems that 'deconvolution' is relevant. 

In case it is relevant, the context is RFID tag inventory, the channel access mechanism is framed slotted ALOHA (FSA) random access, the carrier is 868 MHz (EU) and subcarrier is 256 kHz.

Thank you.
