Excel Cells 2

[Guvnor2000]

Is there a limit on the amount of characters that can be included in one Cell?

Also is there a function so a carriage return can be used within a cell?

Thanks

 

[cheerio]

It was increased from 256 to 65k, I think with Excel 2000 but maybe 97.

However, MS initially forgot that the limit was hardcoded in more than one place so some processes such as copying a sheet got broken. You therefore need to ensure you have the office service packs installed.

The method of entering a carriage return within a cell varies between MS products.

Some use CTRL ENTER others use SHIFT ENTER. ENTER on its own fails because that is taken as a command to enter the data.

 

[Guvnor2000]

How would you force a carriage return in a formula

e.g
=(A1)& (A2) & Carr Return & (B1) & (B2)
which would result in
A1A2
B1B2
in one cell

 

[GlennUK]

Use the CHAR function. Your formula would look like this:

=A1&A2&CHAR(10)&B1&B2

but remember to format the cell so that wrap text is switched on ( menu command Format/Cells/Alignment and tick the Wrap Text checkbox ).


Cheers, Glenn.