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

 

[kalim42]

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

I can Hide column C and D, that is a minor problem
Thanks

Nick

 

[r1998]

Thanks. I am glad that I was able to help
Best of luck