Character Limit

I have a problem with a previously developed worksheet.

Some fields seem to have a 255 character limit. If you enter > 255 then all
you get is a display of hashes eg: ###############################.

Why is there a 255 character limit on my cell? and any ideas how to remove it?

Changing the formatting of the cell does not alter the 255 character limit.
Whether formatted as general or text, there is still a 255 character limit
applied.

Any help is appreciated.

--
I may not know VBA inside out, but from the outside I am looking in.
Dylan Moran - Melbourne Australia

What version of excel are you using?

xl95 had a maximum of 255 characters per cell.

xl97+ has a maximium of almost 32k characters per cell.

But if the cell is formatted as text, then excel has trouble with strings
between 255 and 1024 characters.

But if you format the cell as General, it should display normally. (I've never
seen it fail--so I'd suggest trying it once more.)


Dylan Moran wrote:
>
> I have a problem with a previously developed worksheet.
>
> Some fields seem to have a 255 character limit. If you enter > 255 then all
> you get is a display of hashes eg: ###############################.
>
> Why is there a 255 character limit on my cell? and any ideas how to remove it?
>
> Changing the formatting of the cell does not alter the 255 character limit.
> Whether formatted as general or text, there is still a 255 character limit
> applied.
>
> Any help is appreciated.
>
> --
> I may not know VBA inside out, but from the outside I am looking in.
> Dylan Moran - Melbourne Australia

--

Dave Peterson

Excel 2002. It is formatted as General. I noted you 255 - 1024 comment and
did some testing.

It seems to have trouble with 256-1010 characters.
Anything either side is ok.

--
I may not know VBA inside out, but from the outside I am looking in.
Dylan Moran - Melbourne Australia


"Dave Peterson" wrote:

> What version of excel are you using?
>
> xl95 had a maximum of 255 characters per cell.
>
> xl97+ has a maximium of almost 32k characters per cell.
>
> But if the cell is formatted as text, then excel has trouble with strings
> between 255 and 1024 characters.
>
> But if you format the cell as General, it should display normally. (I've never
> seen it fail--so I'd suggest trying it once more.)
>
>
> Dylan Moran wrote:
> >
> > I have a problem with a previously developed worksheet.
> >
> > Some fields seem to have a 255 character limit. If you enter > 255 then all
> > you get is a display of hashes eg: ###############################.
> >
> > Why is there a 255 character limit on my cell? and any ideas how to remove it?
> >
> > Changing the formatting of the cell does not alter the 255 character limit.
> > Whether formatted as general or text, there is still a 255 character limit
> > applied.
> >
> > Any help is appreciated.
> >
> > --
> > I may not know VBA inside out, but from the outside I am looking in.
> > Dylan Moran - Melbourne Australia
>
> --
>
> Dave Peterson
>

Does that mean that you see your string instead of #######'s?

Dylan Moran wrote:
>
> Excel 2002. It is formatted as General. I noted you 255 - 1024 comment and
> did some testing.
>
> It seems to have trouble with 256-1010 characters.
> Anything either side is ok.
>
> --
> I may not know VBA inside out, but from the outside I am looking in.
> Dylan Moran - Melbourne Australia
>
> "Dave Peterson" wrote:
>
> > What version of excel are you using?
> >
> > xl95 had a maximum of 255 characters per cell.
> >
> > xl97+ has a maximium of almost 32k characters per cell.
> >
> > But if the cell is formatted as text, then excel has trouble with strings
> > between 255 and 1024 characters.
> >
> > But if you format the cell as General, it should display normally. (I've never
> > seen it fail--so I'd suggest trying it once more.)
> >
> >
> > Dylan Moran wrote:
> > >
> > > I have a problem with a previously developed worksheet.
> > >
> > > Some fields seem to have a 255 character limit. If you enter > 255 then all
> > > you get is a display of hashes eg: ###############################.
> > >
> > > Why is there a 255 character limit on my cell? and any ideas how to remove it?
> > >
> > > Changing the formatting of the cell does not alter the 255 character limit.
> > > Whether formatted as general or text, there is still a 255 character limit
> > > applied.
> > >
> > > Any help is appreciated.
> > >
> > > --
> > > I may not know VBA inside out, but from the outside I am looking in.
> > > Dylan Moran - Melbourne Australia
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson

Either side the string shows.

--
I may not know VBA inside out, but from the outside I am looking in.
Dylan Moran - Melbourne Australia


"Dave Peterson" wrote:

> Does that mean that you see your string instead of #######'s?
>
> Dylan Moran wrote:
> >
> > Excel 2002. It is formatted as General. I noted you 255 - 1024 comment and
> > did some testing.
> >
> > It seems to have trouble with 256-1010 characters.
> > Anything either side is ok.
> >
> > --
> > I may not know VBA inside out, but from the outside I am looking in.
> > Dylan Moran - Melbourne Australia
> >
> > "Dave Peterson" wrote:
> >
> > > What version of excel are you using?
> > >
> > > xl95 had a maximum of 255 characters per cell.
> > >
> > > xl97+ has a maximium of almost 32k characters per cell.
> > >
> > > But if the cell is formatted as text, then excel has trouble with strings
> > > between 255 and 1024 characters.
> > >
> > > But if you format the cell as General, it should display normally. (I've never
> > > seen it fail--so I'd suggest trying it once more.)
> > >
> > >
> > > Dylan Moran wrote:
> > > >
> > > > I have a problem with a previously developed worksheet.
> > > >
> > > > Some fields seem to have a 255 character limit. If you enter > 255 then all
> > > > you get is a display of hashes eg: ###############################.
> > > >
> > > > Why is there a 255 character limit on my cell? and any ideas how to remove it?
> > > >
> > > > Changing the formatting of the cell does not alter the 255 character limit.
> > > > Whether formatted as general or text, there is still a 255 character limit
> > > > applied.
> > > >
> > > > Any help is appreciated.
> > > >
> > > > --
> > > > I may not know VBA inside out, but from the outside I am looking in.
> > > > Dylan Moran - Melbourne Australia
> > >
> > > --
> > >
> > > Dave Peterson
> > >
>
> --
>
> Dave Peterson
>

But when it's 300 characters, you see the ######'s or your real string?



Dylan Moran wrote:
>
> Either side the string shows.
>
> --
> I may not know VBA inside out, but from the outside I am looking in.
> Dylan Moran - Melbourne Australia
>
> "Dave Peterson" wrote:
>
> > Does that mean that you see your string instead of #######'s?
> >
> > Dylan Moran wrote:
> > >
> > > Excel 2002. It is formatted as General. I noted you 255 - 1024 comment and
> > > did some testing.
> > >
> > > It seems to have trouble with 256-1010 characters.
> > > Anything either side is ok.
> > >
> > > --
> > > I may not know VBA inside out, but from the outside I am looking in.
> > > Dylan Moran - Melbourne Australia
> > >
> > > "Dave Peterson" wrote:
> > >
> > > > What version of excel are you using?
> > > >
> > > > xl95 had a maximum of 255 characters per cell.
> > > >
> > > > xl97+ has a maximium of almost 32k characters per cell.
> > > >
> > > > But if the cell is formatted as text, then excel has trouble with strings
> > > > between 255 and 1024 characters.
> > > >
> > > > But if you format the cell as General, it should display normally. (I've never
> > > > seen it fail--so I'd suggest trying it once more.)
> > > >
> > > >
> > > > Dylan Moran wrote:
> > > > >
> > > > > I have a problem with a previously developed worksheet.
> > > > >
> > > > > Some fields seem to have a 255 character limit. If you enter > 255 then all
> > > > > you get is a display of hashes eg: ###############################.
> > > > >
> > > > > Why is there a 255 character limit on my cell? and any ideas how to remove it?
> > > > >
> > > > > Changing the formatting of the cell does not alter the 255 character limit.
> > > > > Whether formatted as general or text, there is still a 255 character limit
> > > > > applied.
> > > > >
> > > > > Any help is appreciated.
> > > > >
> > > > > --
> > > > > I may not know VBA inside out, but from the outside I am looking in.
> > > > > Dylan Moran - Melbourne Australia
> > > >
> > > > --
> > > >
> > > > Dave Peterson
> > > >
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson

Long Path Tool should hep to overcome this issue. I would suggest you to try it out.

Originally Posted by Dylan Moran

I have a problem with a previously developed worksheet.

Some fields seem to have a 255 character limit. If you enter > 255 then all
you get is a display of hashes eg: ###############################.

Why is there a 255 character limit on my cell? and any ideas how to remove it?

Changing the formatting of the cell does not alter the 255 character limit.
Whether formatted as general or text, there is still a 255 character limit
applied.

Any help is appreciated.

--
I may not know VBA inside out, but from the outside I am looking in.
Dylan Moran - Melbourne Australia

u can try using Long Path Tool, its the better way to solving your problem bro