How to do this in excel.

A

Adapter

Newbie

Jan 3, 2012

12

2

• Jan 5, 2012

• #1

Hello,

Need some help with excel.

Let's say I have a txt file with 3 lines.

line1
line2
line3

Ok, now, if I copy this into excel, it will show in 3 rows.

What I want to do is, how do I make it stays in 1 row, but have 3 lines.So that, when I copy it back to the txt file, it will have 3 lines.

You guys know how to do this ?

Thanks

 

t0m3313

Regular Member

Sep 11, 2011

224

56

• Jan 5, 2012

• #2

I think you have to mark the 3 fields you want the data in and then paste, this should work You know that row and line is the same, do you?

 

A

Adapter

Newbie

Jan 3, 2012

12

2

• Jan 5, 2012
• Thread Starter Thread Starter

• #3

t0m3313 said:

I think you have to mark the 3 fields you want the data in and then paste, this should work You know that row and line is the same, do you?

Click to expand...

No, that's not what I meant.

I want column A and column B to corresponds.I have 100+ lines and I want row in column A and column B to corresponds.But, in column A, I have only 1 line, but in column B, I have 3 lines.When I copy the column B out and paste in notepad, I want it to show in 3 lines, not 1 line.

I hope you get what I meant.

Thanks

 

Last edited: Jan 5, 2012

CoyoteAssassin

Elite Member

Jan 3, 2010

1,868

3,988

• Jan 5, 2012

• #4

Do you mean that you want to turn

line1
line2
line 3

into...

line1 line2 line3?

If so, respond on here (not PM) and I can help. Let us know as it is not clear (to me).


Make an example for us. You are not doing an excellent job of describing. Thanks.

 

t0m3313

Regular Member

Sep 11, 2011

224

56

• Jan 5, 2012

• #5

 

M

m3ownz

Regular Member

Dec 12, 2009

317

136

• Jan 6, 2012

• #6

Click the CELL you want it in, then click the function bar along the top (the long white bar you can type into). Then click paste. You will then have one cell containing 3 lines.

Im 99% sure thats what you want.

 

D

diablojump

Newbie

Jan 31, 2010

49

8

• Jan 6, 2012

• #7

In excel:
- copy the list (one column, multiple rows)
- select another cell, then select paste special, then select transpose.
It should paste the multiple rows to multiple columns.
I hope that what you meant.

 

virtual.indiano

Regular Member

Apr 24, 2011

445

470

• Jan 6, 2012

• #8

Yeah copy and paste special with transpose option is what you are looking for.

 

CoyoteAssassin

Elite Member

Jan 3, 2010

1,868

3,988

• Jan 6, 2012

• #9

I guess he isn't coming back. It sounds like using ASAP Utilities and transposing the text will do everything and more. I guess he found his answer...

 

A

Adapter

Newbie

Jan 3, 2012

12

2

• Jan 6, 2012
• Thread Starter Thread Starter

• #10

CoyoteAssassin said:

I guess he isn't coming back. It sounds like using ASAP Utilities and transposing the text will do everything and more. I guess he found his answer...

Click to expand...

Lol, actually I'm going back to using notepad (just for my work, not saying they do the same thing).

 

CoyoteAssassin

Elite Member

Jan 3, 2010

1,868

3,988

• Jan 6, 2012

• #11

We are willing to help. We just need to know what you are asking for.

If you, or anyone, doesn't already have it, I HIGHLY recommend you look into ASAP Utilities. It's been a lifesaver and allows me to do pretty much anything in Excel.

Code:

http://www.asap-utilities.com/