HELP!! how can i fix this... see example...

[Lorie]

Missing data in a piovt report. This is a case note, but below this example
is what is showing up in our pivot reports. as you see we are missing lots
of data. This is happening to all our case notes.

Called HOH to see about doing her Intake meeting, they can't start serving
her until it's held. Since I am going on vacation for two weeks, they said
if I get them the paperwork, they can hold the meeting with mom while I am
gone. Called to talk to mom about this, because she is leaving on a business
trip when i get back, she will call them and schedule the meeting without me
there. Started gathering required paperwork for the intake meeting.

but in my pivot report this is all that shows up

Called HOH to see about doing her Intake meeting, they can't start serving
her until it's held. Since I am going on vacation for two weeks, they said
if I get them the paperwork, they can hold the meeting with mom while I am
gone. Called to talk to mom

I am missing alot as you see, what can I do about this?? I really need
your help. Thank you in advance.

 

[Peo Sjoblom]

256 characters, look in help and type in specifications

 

[Lorie]

is there a way to let us know when we reach that? like can i show a count as
we type? if so how would you do that?

 

[Peo Sjoblom]

Not really (at least not in Excel), you can show a count but only after you
have pressed enter
So one way would be to inform all of the limit, then use a formula like this
in another cell

=LEN(D4)

where D4 is the cell where the text is being entered, that way you can see
how many characters have been entered, then when you think that you have
reached about that number of characters press enter, then perhaps it says
204, then select the cell again, press F2 to get into editing mode and type
another 52 characters

but there is no way Excel can tell you this while you are typing, you need
to press enter first

 

[Dave Peterson]

Not as you type.

But you could use another cell with a formula like: =len(a1)

But you have to enter the value for that formula to recalculate.

Maybe using format|Conditional formatting to highlight the cells that exceed 256
characters would be enough:

Select your range (I used A2:A99)
and with A2 the activecell
format|conditional formatting
formula is:
=len(a2)>256

And give it a nice irritating format.

You'll have to enter the value for this to work, too.