Excel 2003 cell formatting

Thanks Gary, but I want to keep all this data in one cell. When I hit enter
it takes me down the the next cell. Any suggestions?
--
Thanks Tia


"Gary''s Student" wrote:
> You need to replace the comma/space with a hard return
>
> Edit > Replace
> in the replace what field, enter comma space
> in the replace with field, just enter CNTRL-j
>
> and do a replace all.
>
> You should see:
>
> "72411 Diet Clerk 2150-3
> 72411 Dietitians Assistant 1706-2
> 72411 Clinical Dietitian 8300-5
> 72411 Clinical Dietitian (Non-Exempt) 8305-1
> 72411 Supr Dietitian Services 8470-1"
>
> --
> Gary''s Student - gsnu200735

The suggested solution will leave all the data in one cell.

The edit>replace removes the commas and replaces with an in-cell line feed.

Re-read and try again.


Gord Dibben MS Excel MVP

On Sat, 4 Aug 2007 10:20:00 -0700, Tia <Tia DeleteThis @discussions.microsoft.com> wrote:

>Thanks Gary, but I want to keep all this data in one cell. When I hit enter
>it takes me down the the next cell. Any suggestions?

Thanks Gord. That did work.

When I am entering the data, how do I get it to format without the , ? Or
do I need to do it this way all the time?
--
Thanks Tia


"Gord Dibben" wrote:

> The suggested solution will leave all the data in one cell.
>
> The edit>replace removes the commas and replaces with an in-cell line feed.
>
> Re-read and try again.
>
>
> Gord Dibben MS Excel MVP
>
> On Sat, 4 Aug 2007 10:20:00 -0700, Tia <Tia.RemoveThis@discussions.microsoft.com> wrote:
>
> >Thanks Gary, but I want to keep all this data in one cell. When I hit enter
> >it takes me down the the next cell. Any suggestions?
>
>

How do you enter the data?

If manually, don't bother typing the comma<space> just hot Alt + Enter when you
want a line feed.

i.e. manually

This is line one Alt + Enter for linefeed
This is line two Alt + Enter for linefeed
This is line three Enter to leave the cell

If coming in from an external source there may be a way to control that, but
need more detail on source.


Gord


On Sat, 4 Aug 2007 12:34:01 -0700, Tia <Tia RemoveThis @discussions.microsoft.com> wrote:

>Thanks Gord. That did work.
>
>When I am entering the data, how do I get it to format without the , ? Or
>do I need to do it this way all the time?