Prev Previous Post   Next Post Next
  #1   Report Post  
JJ
 
Posts: n/a
Default CHAR(10)

I have a spreadsheet that someone else created. This spreadsheet has some
sort of line break I am not familiar with. I thought it was char(10) at
first, but it will not replace. It shows two boxes when the cell format is
unwrapped, however when it wraps, it still shows one box. I have tried to
replace by alt 010, but it will not. The way it appears in the cell is like
when you get the box before you turn on wrap text when using char(10), but it
shows two instead of one. When wrap text is turned on the second string
drops, however one box is still appearing....any suggestions?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 09:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"