ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel formatting of text-- one cell needed (https://www.excelbanter.com/excel-discussion-misc-queries/2115-excel-formatting-text-one-cell-needed.html)

Jonathan Graham

Excel formatting of text-- one cell needed
 
I want to paste txt or doc text into one cell. Instead it populates the
spreadsheet. A colleague who does not know English tried using CNTRL+X and
was able to put the pasted text into one cell but could not duplicate it. Any
ideas?

Sample paste:

-- I want to take this list
-- Or group of statements
-- Into one field in Excel

But I get

Cell

A1 -- I want to take this list
A2 -- Or group of statements
A§ -- Into one field in Excel

Thank you

JE McGimpsey

Double click in the cell to enter Edit Mode (or select the Formula box
in the Formula bar) before pasting.

In article ,
Jonathan Graham <Jonathan wrote:

I want to paste txt or doc text into one cell. Instead it populates the
spreadsheet. A colleague who does not know English tried using CNTRL+X and
was able to put the pasted text into one cell but could not duplicate it. Any
ideas?

Sample paste:

-- I want to take this list
-- Or group of statements
-- Into one field in Excel

But I get

Cell

A1 -- I want to take this list
A2 -- Or group of statements
A§ -- Into one field in Excel

Thank you



All times are GMT +1. The time now is 08:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com