Merge cells

[kalim42]

I need to import bank statements and convert to excel, but in the conversion process in excel I get 2 or 3 columns for each line. In order to keep the records complete I need to merge all columns.
There is way or formula that I can use to merge all the columns?
Thanks in advance.
Nick

 

[r1998]

Hello and welcome to MrExcel forum
do not merge, just select data n use TEXTtoCOLUMNS option

 

[kalim42]

Hello and welcome to MrExcel forum
do not merge, just select data n use TEXTtoCOLUMNS option

I'm A little dumb in excel, how I can do the text to column? I can create an example to ilustrate what I'm looking to do

 

[Michael M]

another option would be to select the cells involved
rclick and select format cells
select Alignment tab in the popup window
in the horizontal dropdown box, select "center across selection"
Ok

As already mentioned.....do not use merged cells....it's one thing that should never have been allowed to be in Excel

 

[kalim42]

another option would be to select the cells involved
rclick and select format cells
select Alignment tab in the popup window
in the horizontal dropdown box, select "center across selection"
Ok

As already mentioned.....do not use merged cells....it's one thing that should never have been allowed to be in Excel

thanks Michael M, this is an example in this case text in column C need to be along with text in column B
Column A Column B Column C Column D

[TABLE="width: 932"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]08/10[/TD]
[TD]Card Purchase[/TD]
[TD]08/10 Igt [/TD]
[TD] [/TD]
[TD] 1.00[/TD]
[/TR]
[TR]
[TD]08/13[/TD]
[TD]Card Purchase[/TD]
[TD]08/10 Interglass [/TD]
[TD] [/TD]
[TD] 1.00[/TD]
[/TR]
[TR]
[TD]08/16[/TD]
[TD]Card Purchase With Pin 08/16 The Home Depot [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 1.00[/TD]
[/TR]
[TR]
[TD]08/16[/TD]
[TD]Card Purchase With Pin 08/16 Lowe's [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 1.00[/TD]
[/TR]
[TR]
[TD]08/17[/TD]
[TD]Card Purchase[/TD]
[TD]08/17 Igt [/TD]
[TD] [/TD]
[TD] 1.00
[/TD]
[/TR]
</tbody>[/TABLE]
In this case I can do what you suggested me before?
Thanks in advance

Nick

 

[r1998]

Hello
right click on column B header, click on Insert, then in cell B1 use this formula

=CONCATENATE(C1,D1)

press enter n then 1) drag down the + sign on bottom right corner of cell B1 OR 2) double click on that plus sign..... then right click on column header of column C and delete it, and similarly delete column D

 

[kalim42]

Hello
right click on column B header, click on Insert, then in cell B1 use this formula

=CONCATENATE(C1,D1)

press enter n then 1) drag down the + sign on bottom right corner of cell B1 OR 2) double click on that plus sign..... then right click on column header of column C and delete it, and similarly delete column D

Hi r1998

It doesn't work, see below, cell doesn't concatenate and the formula is dragged to subsequent cells

[TABLE="width: 233"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]08/02[/TD]
[TD]=CONCATENATE (C5:D5)[/TD]
[/TR]
[TR]
[TD]08/02[/TD]
[TD]=CONCATENATE (C5:D5)[/TD]
[/TR]
[TR]
[TD]08/03[/TD]
[TD]=CONCATENATE (C5:D5)[/TD]
[/TR]
[TR]
[TD]08/06[/TD]
[TD]=CONCATENATE (C5:D5)[/TD]
[/TR]
[TR]
[TD]08/06[/TD]
[TD]=CONCATENATE (C5:D5)[/TD]
[/TR]
[TR]
[TD]08/06[/TD]
[TD]=CONCATENATE (C5:D5)[/TD]
[/TR]
</tbody>[/TABLE]

 

[r1998]

deleting column C and D will give error in Column B
you will have to select and copy the contents of column B, then click on an empty column, say column F, so right click on cell f1, then click on Paste Special n click on values
n then copy and paste that data in column B n then delete column c and d

 

[r1998]

it must be

[COLOR=#333333]=CONCATENATE (C5,D5)[/COLOR]

 

[kalim42]

it must be

[COLOR=#333333]=CONCATENATE (C5,D5)[/COLOR]

Sorry r1998, I did with "," but looks that the program with which I convert from PDF to excel some restrictions, now I copied some cells in a new workbook, entered your formula, and it works.
From the new workbook I copied the concatenates cells, went back to the original, paste the formula, and it works, now I need to see which is the restrictions of that convert from PDF to excel program
Thank you

Nick