how do I make more then one line of pasted text not move to one cell?

Hello. How do I make one block of text I pasted not go in to 2 cells and if
I want to merge those 2 cells together in to one cell let's say merge 5d in
to 4d, is that possible? Thanks. Oh, I'm visually impaired so is this
possible with the keyboard? Thanks.

If you click on the cell but paste into the formula bar at the top
The whole text will go into the cell

Steve

On Wed, 26 Jul 2006 03:57:49 +0100, marrie <[email protected]> wrote:

> Hello. How do I make one block of text I pasted not go in to 2 cells =
=

> and if
> I want to merge those 2 cells together in to one cell let's say merge =
5d =

> in
> to 4d, is that possible? Thanks. Oh, I'm visually impaired so is this
> possible with the keyboard? Thanks.
>
>



-- =

Steve (3)

Is there a way to do that with the keyboard ane menues? I know control+v
is the paste command
"SteveW" <[email protected]> wrote in message
news:op.tc955uzcevjsnp@enigma03...
If you click on the cell but paste into the formula bar at the top
The whole text will go into the cell

Steve

On Wed, 26 Jul 2006 03:57:49 +0100, marrie <[email protected]> wrote:

> Hello. How do I make one block of text I pasted not go in to 2 cells and
> if
> I want to merge those 2 cells together in to one cell let's say merge 5d
> in
> to 4d, is that possible? Thanks. Oh, I'm visually impaired so is this
> possible with the keyboard? Thanks.
>
>



--
Steve (3)

Hi Marrie

Yes Control + V will do it for you.
Control + C is for Copy
Control + X is for Cut

If you have data that is in 2 cells and you want to join it together
then use
=D4&" "&D5

--
Regards

Roger Govier


"marrie" <[email protected]> wrote in message
news:[email protected]...
> Is there a way to do that with the keyboard ane menues? I know
> control+v is the paste command
> "SteveW" <[email protected]> wrote in message
> news:op.tc955uzcevjsnp@enigma03...
> If you click on the cell but paste into the formula bar at the top
> The whole text will go into the cell
>
> Steve
>
> On Wed, 26 Jul 2006 03:57:49 +0100, marrie <[email protected]> wrote:
>
>> Hello. How do I make one block of text I pasted not go in to 2 cells
>> and if
>> I want to merge those 2 cells together in to one cell let's say merge
>> 5d in
>> to 4d, is that possible? Thanks. Oh, I'm visually impaired so is this
>> possible with the keyboard? Thanks.
>>
>>
>
>
>
> --
> Steve (3)
>

Where would I put that? I'm really really new at excel, IE I just started
using it today.
"Roger Govier" <[email protected]> wrote in message
news:[email protected]...
> Hi Marrie
>
> Yes Control + V will do it for you.
> Control + C is for Copy
> Control + X is for Cut
>
> If you have data that is in 2 cells and you want to join it together then
> use
> =D4&" "&D5
>
> --
> Regards
>
> Roger Govier
>
>
> "marrie" <[email protected]> wrote in message
> news:[email protected]...
>> Is there a way to do that with the keyboard ane menues? I know
>> control+v is the paste command
>> "SteveW" <[email protected]> wrote in message
>> news:op.tc955uzcevjsnp@enigma03...
>> If you click on the cell but paste into the formula bar at the top
>> The whole text will go into the cell
>>
>> Steve
>>
>> On Wed, 26 Jul 2006 03:57:49 +0100, marrie <[email protected]> wrote:
>>
>>> Hello. How do I make one block of text I pasted not go in to 2 cells
>>> and if
>>> I want to merge those 2 cells together in to one cell let's say merge 5d
>>> in
>>> to 4d, is that possible? Thanks. Oh, I'm visually impaired so is this
>>> possible with the keyboard? Thanks.
>>>
>>>
>>
>>
>>
>> --
>> Steve (3)
>>
>
>

Hi Marrie

You would put the formula in another cell, e.g. in cell E4 enter the
formula.
That will now contain what is in D4 plus a space then what is in D5.

In order to "fix" the value in E4 so it does not alter if you alter or
delete either of D4 or D5, you need to then copy cell E4 and Paste
Special>Values back to cell E4. This will change it from a formula, to
the result of the formula.
Now you have your concatenated text, and you can happily clear the
contents of D4 and D5.

If you want to do the Copy and Paste Special>Values with keystrokes,
then select cell E4
Control + C
Alt + S then Enter
Alt +V then Enter

Enjoy your new life in the Excel world<bg> and do post back if you have
more queries.

--
Regards

Roger Govier


"marrie" <[email protected]> wrote in message
news:[email protected]...
> Where would I put that? I'm really really new at excel, IE I just
> started using it today.
> "Roger Govier" <[email protected]> wrote in message
> news:[email protected]...
>> Hi Marrie
>>
>> Yes Control + V will do it for you.
>> Control + C is for Copy
>> Control + X is for Cut
>>
>> If you have data that is in 2 cells and you want to join it together
>> then use
>> =D4&" "&D5
>>
>> --
>> Regards
>>
>> Roger Govier
>>
>>
>> "marrie" <[email protected]> wrote in message
>> news:[email protected]...
>>> Is there a way to do that with the keyboard ane menues? I know
>>> control+v is the paste command
>>> "SteveW" <[email protected]> wrote in message
>>> news:op.tc955uzcevjsnp@enigma03...
>>> If you click on the cell but paste into the formula bar at the top
>>> The whole text will go into the cell
>>>
>>> Steve
>>>
>>> On Wed, 26 Jul 2006 03:57:49 +0100, marrie <[email protected]>
>>> wrote:
>>>
>>>> Hello. How do I make one block of text I pasted not go in to 2
>>>> cells and if
>>>> I want to merge those 2 cells together in to one cell let's say
>>>> merge 5d in
>>>> to 4d, is that possible? Thanks. Oh, I'm visually impaired so is
>>>> this
>>>> possible with the keyboard? Thanks.
>>>>
>>>>
>>>
>>>
>>>
>>> --
>>> Steve (3)
>>>
>>
>>
>
>

Unfortunately NO, well not in the normal setup.

So, we'll have to change this
Tools->Options..
Chose Edit tab, then uncheck the *Edit directly in cell*

You want to Click on Cell, then press F2 to *edit the cell*
Then paste (and Ctrl+V will do that) your text into the formula bar at t=
he =

top.

I see from a later post that you are new to excel
Sorry to ask, but lots of new users start pasting text - remember Word i=
s =

best for documents, even short quick notes.

And cell references are best written as LetterDigit, ie D4, D5


Steve


On Wed, 26 Jul 2006 07:40:06 +0100, marrie <[email protected]> wrote:

> Is there a way to do that with the keyboard ane menues? I know =

> control+v
> is the paste command
> "SteveW" <[email protected]> wrote in message
> news:op.tc955uzcevjsnp@enigma03...
> If you click on the cell but paste into the formula bar at the top
> The whole text will go into the cell
>
> Steve
>
> On Wed, 26 Jul 2006 03:57:49 +0100, marrie <[email protected]> wrote:
>
>> Hello. How do I make one block of text I pasted not go in to 2 cells=
=

>> and
>> if
>> I want to merge those 2 cells together in to one cell let's say merge=
5d
>> in
>> to 4d, is that possible? Thanks. Oh, I'm visually impaired so is this=

>> possible with the keyboard? Thanks.
>>
>>

basically I'm creating a table contaning some names and interests. The
interests of these people are the problem as they are taking up more then
one cell.
"SteveW" <[email protected]> wrote in message
news:op.tdaf0zhhevjsnp@enigma03...
Unfortunately NO, well not in the normal setup.

So, we'll have to change this
Tools->Options..
Chose Edit tab, then uncheck the *Edit directly in cell*

You want to Click on Cell, then press F2 to *edit the cell*
Then paste (and Ctrl+V will do that) your text into the formula bar at the
top.

I see from a later post that you are new to excel
Sorry to ask, but lots of new users start pasting text - remember Word is
best for documents, even short quick notes.

And cell references are best written as LetterDigit, ie D4, D5


Steve


On Wed, 26 Jul 2006 07:40:06 +0100, marrie <[email protected]> wrote:

> Is there a way to do that with the keyboard ane menues? I know
> control+v
> is the paste command
> "SteveW" <[email protected]> wrote in message
> news:op.tc955uzcevjsnp@enigma03...
> If you click on the cell but paste into the formula bar at the top
> The whole text will go into the cell
>
> Steve
>
> On Wed, 26 Jul 2006 03:57:49 +0100, marrie <[email protected]> wrote:
>
>> Hello. How do I make one block of text I pasted not go in to 2 cells
>> and
>> if
>> I want to merge those 2 cells together in to one cell let's say merge 5d
>> in
>> to 4d, is that possible? Thanks. Oh, I'm visually impaired so is this
>> possible with the keyboard? Thanks.
>>
>>

basically I'm creating a table contaning some names and interests. The
interests of these people are the problem as they are taking up more then
one cell.
"SteveW" <[email protected]> wrote in message
news:op.tdaf0zhhevjsnp@enigma03...
Unfortunately NO, well not in the normal setup.

So, we'll have to change this
Tools->Options..
Chose Edit tab, then uncheck the *Edit directly in cell*

You want to Click on Cell, then press F2 to *edit the cell*
Then paste (and Ctrl+V will do that) your text into the formula bar at the
top.

I see from a later post that you are new to excel
Sorry to ask, but lots of new users start pasting text - remember Word is
best for documents, even short quick notes.

And cell references are best written as LetterDigit, ie D4, D5


Steve


On Wed, 26 Jul 2006 07:40:06 +0100, marrie <[email protected]> wrote:

> Is there a way to do that with the keyboard ane menues? I know
> control+v
> is the paste command
> "SteveW" <[email protected]> wrote in message
> news:op.tc955uzcevjsnp@enigma03...
> If you click on the cell but paste into the formula bar at the top
> The whole text will go into the cell
>
> Steve
>
> On Wed, 26 Jul 2006 03:57:49 +0100, marrie <[email protected]> wrote:
>
>> Hello. How do I make one block of text I pasted not go in to 2 cells
>> and
>> if
>> I want to merge those 2 cells together in to one cell let's say merge 5d
>> in
>> to 4d, is that possible? Thanks. Oh, I'm visually impaired so is this
>> possible with the keyboard? Thanks.
>>
>>

Hi Marrie

There is no problem in storing lots of text (up to 32,667 characters) in
a single cell, but I believe that only the first 1024 characters are
normally visible. There are ways of seeing all of the text if you do run
over 1024 characters.

In order to enter data easily, first format the cells
Format>cells>Alignment>Wrap text
If you want data to be entered on separate lines with the cell, then use
Alt Enter to force a line feed.

This also enables you to overcome the limit of 1024 characters
displayed, but I'm not sure what the maximum display is if you use this
method.


--
Regards

Roger Govier


"marrie" <[email protected]> wrote in message
news:%[email protected]...
> basically I'm creating a table contaning some names and interests. The
> interests of these people are the problem as they are taking up more
> then one cell.
> "SteveW" <[email protected]> wrote in message
> news:op.tdaf0zhhevjsnp@enigma03...
> Unfortunately NO, well not in the normal setup.
>
> So, we'll have to change this
> Tools->Options..
> Chose Edit tab, then uncheck the *Edit directly in cell*
>
> You want to Click on Cell, then press F2 to *edit the cell*
> Then paste (and Ctrl+V will do that) your text into the formula bar at
> the
> top.
>
> I see from a later post that you are new to excel
> Sorry to ask, but lots of new users start pasting text - remember Word
> is
> best for documents, even short quick notes.
>
> And cell references are best written as LetterDigit, ie D4, D5
>
>
> Steve
>
>
> On Wed, 26 Jul 2006 07:40:06 +0100, marrie <[email protected]> wrote:
>
>> Is there a way to do that with the keyboard ane menues? I know
>> control+v
>> is the paste command
>> "SteveW" <[email protected]> wrote in message
>> news:op.tc955uzcevjsnp@enigma03...
>> If you click on the cell but paste into the formula bar at the top
>> The whole text will go into the cell
>>
>> Steve
>>
>> On Wed, 26 Jul 2006 03:57:49 +0100, marrie <[email protected]> wrote:
>>
>>> Hello. How do I make one block of text I pasted not go in to 2
>>> cells and
>>> if
>>> I want to merge those 2 cells together in to one cell let's say
>>> merge 5d
>>> in
>>> to 4d, is that possible? Thanks. Oh, I'm visually impaired so is
>>> this
>>> possible with the keyboard? Thanks.
>>>
>>>
>
>

Thanks. I'll find out via your method.
"Roger Govier" <[email protected]> wrote in message
news:%[email protected]...
> Hi Marrie
>
> There is no problem in storing lots of text (up to 32,667 characters) in a
> single cell, but I believe that only the first 1024 characters are
> normally visible. There are ways of seeing all of the text if you do run
> over 1024 characters.
>
> In order to enter data easily, first format the cells
> Format>cells>Alignment>Wrap text
> If you want data to be entered on separate lines with the cell, then use
> Alt Enter to force a line feed.
>
> This also enables you to overcome the limit of 1024 characters displayed,
> but I'm not sure what the maximum display is if you use this method.
>
>
> --
> Regards
>
> Roger Govier
>
>
> "marrie" <[email protected]> wrote in message
> news:%[email protected]...
>> basically I'm creating a table contaning some names and interests. The
>> interests of these people are the problem as they are taking up more
>> then one cell.
>> "SteveW" <[email protected]> wrote in message
>> news:op.tdaf0zhhevjsnp@enigma03...
>> Unfortunately NO, well not in the normal setup.
>>
>> So, we'll have to change this
>> Tools->Options..
>> Chose Edit tab, then uncheck the *Edit directly in cell*
>>
>> You want to Click on Cell, then press F2 to *edit the cell*
>> Then paste (and Ctrl+V will do that) your text into the formula bar at
>> the
>> top.
>>
>> I see from a later post that you are new to excel
>> Sorry to ask, but lots of new users start pasting text - remember Word is
>> best for documents, even short quick notes.
>>
>> And cell references are best written as LetterDigit, ie D4, D5
>>
>>
>> Steve
>>
>>
>> On Wed, 26 Jul 2006 07:40:06 +0100, marrie <[email protected]> wrote:
>>
>>> Is there a way to do that with the keyboard ane menues? I know
>>> control+v
>>> is the paste command
>>> "SteveW" <[email protected]> wrote in message
>>> news:op.tc955uzcevjsnp@enigma03...
>>> If you click on the cell but paste into the formula bar at the top
>>> The whole text will go into the cell
>>>
>>> Steve
>>>
>>> On Wed, 26 Jul 2006 03:57:49 +0100, marrie <[email protected]> wrote:
>>>
>>>> Hello. How do I make one block of text I pasted not go in to 2 cells
>>>> and
>>>> if
>>>> I want to merge those 2 cells together in to one cell let's say merge
>>>> 5d
>>>> in
>>>> to 4d, is that possible? Thanks. Oh, I'm visually impaired so is this
>>>> possible with the keyboard? Thanks.
>>>>
>>>>
>>
>>
>
>