![]() ![]() ![]() ![]() I (for one) would first be wanting to know why you want to populate 50+ individual sheets with all that data rather than continue to build a single database that can at any time be used to populate another sheet for a nice looking printout. But what, I wonder, is that reason? Why not just create them one at a time as needed? If, on the other hand, you need to show these records for some reason in an Excel format (if, that is, the row and column set up is integral with your goal) then, yes, it would be fairly easy to do using one of several LOOKUP functions or INDEX and MATCH as the basis for extracting the various fields and populating the target sheet. If you're really creating a form letter (as opposed to just using that as an analog) then Word's Mail Merge, with Excel as the data source, would be the way to go. Here, replace Mahesh and Makvana with your own values that you want to join.My help will come in the form of questions.įirst, what is it that you are really looking to accomplish at the end of all this? Do you really need 50+ copies of the same spreadsheet, each populated by one of 50+ different records? That doesn't sound very efficient. If you want to specify the values in the function itself, then type the function as follows. Then choose the cell in which you want to display the concatenation result. To use the function, open your spreadsheet with Excel. This function replaces the legacy CONCATENATE function and allows you to merge your values in newer versions of Excel. To help you join your values, Excel also offers a function called CONCAT. RELATED: How to Merge Two Columns in Microsoft Excel Concatenate Using the CONCAT Function in Excel You will have to add that space manually, and to do that, use the formula as below: =B2&" "&C2Īnd that’s how you bring values from multiple cells together in a single cell. You’ll notice that Excel doesn’t add a space between two values. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |