Excel help...

[NYPinTA]

I am trying to take a list and switch it to Excel. Problem is, some of the stuff that I want to fit into one cell is three lines long and it keeps splitting it up. One line- one cell.
Then, I changed the stuff from 3 lines to one and figured I could fix it after I put it into one cell. No.
I hardly ever use Excel. I think this is why. :eh:

Help. Please.

Thanks.
:)

[BritAngie]

One cell will take heaps and heaps of characters and show them all unless there is something in the cell next to it. How are you trying to move the data from one to the other? Are you doing a copy and paste or trying to open another format of document into excel?

[eta_carinae]

Do you mean that it won't let you put 3 lines worth of text into one cell? Or that it just doesn't display all of it?

[NYPinTA]

One cell will take heaps and heaps of characters and show them all unless there is something in the cell next to it. How are you trying to move the data from one to the other? Are you doing a copy and paste or trying to open another format of document into excel?

Yep. I have the list in Word.

Do you mean that it won't let you put 3 lines worth of text into one cell? Or that it just doesn't display all of it?

It takes something that looks like this:

Eastchester Branch
1385 East Gun Hill Road
Bronx NY 10469

And splits each line into its own cell. I want the whole thing to go into one.
I moved all the lines together like this:

Allerton Branch 2740 Barnes Avenue Bronx NY 10467

And figured I could move the lines how I wanted them after I got them all in one box... like you can when you add a table in Word... but I don't know if that is possible.

[eta_carinae]

Hmmm. well, if it's splitting the three lines into three cells, you could just merge the three cells into one. Or you could let it put it all into one cell, highlight an area you think will fit the lines into three rows, and then right click, format cells, alignment, and click on wrap text and merge cells. I think the first option would be easier

[Kurt_eh]

This command works too:

=CONCATENATE(A2,A3,A4) or (A1,B1,C1) depending if it's splitting the text horizontally or vertically.

It'll merge the text together, but you have to make sure to add a space at the end of each text cell because it won't do it for you.

Then it's a matter of copying the merged cells together and right-click | Paste Special | Values

[NYPinTA]

This command works too:

=CONCATENATE(A2,A3,A4) or (A1,B1,C1) depending if it's splitting the text horizontally or vertically.

Vertically. Didn't know you could merge cells. But it makes sense. :)

It'll merge the text together, but you have to make sure to add a space at the end of each text cell because it won't do it for you.
Umm.. what?

Then it's a matter of copying the merged cells together and right-click | Paste Special | Values

Again... what?

[Kurt_eh]

CONCATENATE(A2,A3,A4)

What it does is something like this: (assume the first line is the A2 cell) it takes this:

Hi NYPitA
EXCEL Sucks
Because it's a microsith program


and turns it into:
Hi NYPitAEXCEL SucksBecause it's a microsith program

Unless you type a space at the end of each line...

As for that last sentence. Sorry.

The concatenate command will merge the cells together in the cell you write the command in, but the other cells are still there on the screen.

In my example above: when you activate each cell, it will look like:
(assuming the =concat... is cell A1 and that _ is just a spacebar)

=CONCATENATE(A2,A3,A4)
Hi NYPitA_
EXCEL Sucks_
Because it's a microsith program

and the result is:
Hi NYPitA EXCEL Sucks Because it's a microsith program
Hi NYPitA_
EXCEL Sucks_
Because it's a microsith program

If you want to delete the extra lines you have to copy the "Hi NYPitA EXCEL Sucks Because it's a microsith program" and, in the same cell, right click your mouse, select "paste Special" and then click "values". That will make the A1 cell be the phrase "Hi NYPitA EXCEL Sucks Because it's a microsith program" instead of the formula. Then you can delete the other cels without a problem.

[eta_carinae]

Ok, I was playing around with this. What I said earlier about just merging the cells won't work if you already have data in them. What you could do is just wrap the text. I made some screenshots for you. I would start with the single line (one cell). If you have space issues and don't want an entire row to be this wide, you could merge the cells and wrap the text at the same time.

[NYPinTA]

Thanks guys! :hug:

[Mickie]

Except that I want the information all in one row, but not all in one cell. Branch name should be in cell A, Address in Cell B, City in Cell C etc...