Cell Text run-on question

  • Thread starter Thread starter Andrew
  • Start date Start date
A

Andrew

Hi, I assume this question has been answered previously, but I could
not find the answer to it from searching google.

Question:

Assume cell A1 has a long text string, say 50 characters and spills
over into the next cell (B1).

If B1 has text in it, then A1 only shows what fits in A1.

But if B1 is blank, then the text in A1 spills over to B1.

Is there anyway to not permit the text in cell A1 to spill over to B1
(assuming B1 is blank)? (without having to write a macro to figure
this out)

Thanks, Andrew
 
Andrew

Quick and dirty solution!! Select the cells in column B. Press spacebar and
hit Ctrl + Enter. This will shove a space into each B cell and stop the
overflow.

Andy.
 
Hi Andrew

Why not simply wrap text in A1?
(Format / Cells / Alignment --> Text Control : check "Wrap Text")
 
Dave,

thanks, it's been awhile since i have used excel via VBA. your
solution is the best option as I am running a series of scripts.

Thanks!
Andrew
 
Back
Top