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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

marrie - 26 Jul 2006 03:57 GMT

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.

Reply to this Message

SteveW - 26 Jul 2006 06:14 GMT

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

Steve

> 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.

Signature

Steve (3)

Reply to this Message

marrie - 26 Jul 2006 07:40 GMT

Is there a way to do that with the keyboard ane menues? I know control+v
is the paste command
If you click on the cell but paste into the formula bar at the top
The whole text will go into the cell

Steve

> 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.

Signature

Steve (3)

Reply to this Message

Roger Govier - 26 Jul 2006 07:54 GMT

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

Signature

Regards

Roger Govier

> Is there a way to do that with the keyboard ane menues? I know
> control+v is the paste command
[quoted text clipped - 9 lines]
>> to 4d, is that possible? Thanks. Oh, I'm visually impaired so is this
>> possible with the keyboard? Thanks.

Reply to this Message

marrie - 26 Jul 2006 08:17 GMT

Where would I put that? I'm really really new at excel, IE I just started
using it today.

> Hi Marrie
>
[quoted text clipped - 19 lines]
>>> to 4d, is that possible? Thanks. Oh, I'm visually impaired so is this
>>> possible with the keyboard? Thanks.

Reply to this Message

Roger Govier - 26 Jul 2006 08:40 GMT

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.

Signature

Regards

Roger Govier

> Where would I put that? I'm really really new at excel, IE I just
> started using it today.
[quoted text clipped - 25 lines]
>>>> this
>>>> possible with the keyboard? Thanks.

Reply to this Message

SteveW - 26 Jul 2006 09:47 GMT

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

> Is there a way to do that with the keyboard ane menues? I know
> control+v
[quoted text clipped - 11 lines]
>> to 4d, is that possible? Thanks. Oh, I'm visually impaired so is this
>> possible with the keyboard? Thanks.

Reply to this Message

marrie - 26 Jul 2006 18:36 GMT

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.
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

Reply to this Message

Roger Govier - 26 Jul 2006 19:30 GMT

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.

Signature

Regards

Roger Govier

> 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
[quoted text clipped - 36 lines]
>>> this
>>> possible with the keyboard? Thanks.

Reply to this Message

marrie - 26 Jul 2006 20:22 GMT

Thanks. I'll find out via your method.

> Hi Marrie
>
[quoted text clipped - 49 lines]
>>>> to 4d, is that possible? Thanks. Oh, I'm visually impaired so is this
>>>> possible with the keyboard? Thanks.

Reply to this Message

Rate this thread: