Help / Keyword = Specifications
Length of cell contents (text)32,767 characters. Only 1,024 display in a
cell; all 32,767 display in the formula bar.
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"EaglesNest" wrote in message
...
Dave,
Yes the sheets are in the same workbook. As I said it works, just doesn't
look as though it does. After I run the formula down through all 3000
rows,
some display correctly, some do not. However, when I save the file as a
CSV,
and then reopen it using the CSV everything is there the way it should
be...Perplexed...
"Dave Peterson" wrote:
Are your sheets in the same workbook?
If yes, then your (corrected) formula:
=concatenate("!!<",CellDataFromOriginalSheet,"!!" )
Worked ok for me.
If the worksheets were in different workbooks, then the fromula worked
ok for me
as long as the "sending" workbook was open.
When I closed that sending workbook and recalculated that formula, the
results
got truncated to 255 characters. (That's the way excel works.)
EaglesNest wrote:
I have a spreadsheet with descriptions that are well over the 255
character
limit for a cell. I need to move that data to another sheet and add
characters to the beginning and end of the string. The formula that I
use is
=concatenate("!!<",CellDataFromOriginalSheet,"!!) that formula works
for
all cells in the original sheet with the exception of those that are
longer
than 255 characters. It truncates those that are longer. If I do a
simple
range copy from the original sheet to the new sheet then all of the
cell
contents are copied over and it will not truncate. How can I add the
beginning !!< and ending !! characters to the entire content of the
sheet?
Now before you tell me to edit each line seperately please be advised
that
there are 3,046 lines of description that need to be copied to the new
sheet.
I was going to try a find and replace but there isn't any one
character that
I can search on at the beginning.
--
Dave Peterson
|