ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel - long paragraph across multiple cells (https://www.excelbanter.com/excel-discussion-misc-queries/91377-excel-long-paragraph-across-multiple-cells.html)

dlmiranda

Excel - long paragraph across multiple cells
 
I'm trying to insert a long paragraph in an excel document across multiple
cells/rows. Keep getting back ### as display. I've changed the format to
wrap text and ensured merge cells was selected.

Dave Peterson

Excel - long paragraph across multiple cells
 
Try changing the format to General (from Text).

dlmiranda wrote:

I'm trying to insert a long paragraph in an excel document across multiple
cells/rows. Keep getting back ### as display. I've changed the format to
wrap text and ensured merge cells was selected.


--

Dave Peterson

simonsmith

Excel - long paragraph across multiple cells
 

Have you tried pasting special and changing the type of text that you
are pasting into the cell/ cells?
Also you may want to try eidt, clear all in the area you are working as
the cell may have been formatted in some manner

SS


--
simonsmith
------------------------------------------------------------------------
simonsmith's Profile: http://www.excelforum.com/member.php...o&userid=34235
View this thread: http://www.excelforum.com/showthread...hreadid=546946



All times are GMT +1. The time now is 01:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com