I have an excel file that in one of the columns to be merged is in date format. I format the column to ensure the date is in English format ie day, month, year but when I merge it to word it changes it to the american format month, day year yet the word document is set up for English UK help!
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
Merging Columns In Excel
Now that we've clarified what merging columns actually means, we can explore how to do it. The first step is to perform the merge for the first cells. Let's go back to our first example and suppose that we are merging column A that contains first names with column B that contains second names. We'll put the merged columns into column C. To merge cell A1 with cell B1 we woul type the following into cell C1:=A1&" "&B1
It looks like you have chosen the wrong data file. Probably an earlier version of your data still present in some folder. Check these Do you have column headings for every column? Make sure which folder contain the file? What exactly is the name? When you are in the Microsoft word, make sure you select the correct data file for your mail merge. If you have selected the correct data file, when you attempt to insert the merge fields, there is no way, it give wrong field names. The only reason you get the erong field names is because you have the wrong excel file for your data. Fix this problem first, then the rest will sort themselves out. Have a good day. luciana44
If the column names and orders are same across files, then you can directly use the MS Excel's import data function, this will do your job.
Alternatively, if you want to do it manually, import each file in separate excel worksheet using data import wizard or simple copy paste of data (in latter case you have to use Text-to-Col feature of excel), and then manually append all figures (copy-paste in one go) to any external excel sheet.
Then finally, export/save as that external sheet to any filename of your choice.