How to merge data in cells

Posted on Nov 20, 2013 3:27 AM, Excel Help Forum | www.excelforum.com

Some one at the office did the following before but they are not here any more and I need to create an account number using two data from two cells.
Lets say 'A1' 901359 'A2' PA
I need it to look like
PA-901-359
Any help out there.
Do I merge the cells first into one then use a different formula to add the '-'?
Thanks for the help!!!!
Tom

Similar Messages
  1. Merge data of two duplicate rows in excel
  2. Merge Two cells
  3. Merge data from sheet 2 to sheet 1 based on the required criteria
  4. Merge Selected cells and shift column contents Left
  5. Merge Data - Multiple Rows to One Row
  6. Excel as a Merge Data Source pulls blank data
  7. Retaining the merge of cells even after data import
  8. If cell contains certain values merge adjacent cells
  9. VBA Merge Multiple Cells
  10. Mail merge document doesn't print anything except the merged data
  11. Excel VBA - Merge adjacent cells from given list of all cells to be merged
  12. Core Data Cells not updating correctly.
  13. 'Mail merge' data between files
  14. Merge neighboring cells in the same column
  15. Merge files from a directory in one worksheet and match the data with file names
  16. Merge cells using EPPlus?
  17. Compare And Merge Data From Two Different Workbooks
  18. How to merge two cells in excel(both with contents) keeping the formatting intact using VBA?
  19. How to merge cells using Spreadsheet::WriteExcel using Merge_range function?

Merge data of two duplicate rows in excel

Posted on Feb 12, 2014 12:56 PM,

So I have a huge data set in excel (almost 6000 rows), where I have certain duplicate rows(not all), such as below: Batman 1801.7 214.13 1587.57 Batman 1985.8 204.69 1781.11 I have to merge these cells as one, like the one below: Batman ...

Read RepliesRead Related

Merge Two cells

Posted on Aug 13, 2014 10:24 AM,

Hi, I need to merge two cells in the sheet. I have been putting data through beow code and selecting the columns & rows on the basis of varibale. I need to merge cells with the help of that varibale. My code is as below VB: With Sheets(vtabname)...

Read RepliesRead Related

Merge data from sheet 2 to sheet 1 based on the required criteria

Posted on May 07, 2014 11:41 AM,

Merge data from sheet 2 to sheet 1 based on the required criteria Hello everyone, I need to merge data from sheet 2 to data on sheet1. Sheet 1 data is in the format given below with start date in G column and campaign ID in column H.Start Date...

Read RepliesRead Related

Merge Selected cells and shift column contents Left

Posted on Jul 02, 2014 6:22 AM,

I have the code below to merge selected cells in one row and then shift the cells to the right of selected cells to the left. The only problem is that if I select cells in more than one row, it merges all of the selected cells in different rows to one cell. Any ideas to modify this to only merge within ...

Read RepliesRead Related

Merge Data - Multiple Rows to One Row

Posted on Aug 29, 2014 4:02 AM,

Hi, I am trying to merge data from multiple rows into one row for each unique ID. Does anyone have an example that I can replicate on how to do this on a table, maybe a query or something like that. Attached img shows what I am trying to do. Thanks. Fen ...

Read RepliesRead Related

Excel as a Merge Data Source pulls blank data

Posted on Apr 08, 2014 4:47 AM,

I have an Excel data source that I'm useing to perform a mail merge in Word 2007.  The data source currently has a total of 7 records, however, when I perform my merge I get a total of 27 merged documents (20 of them blank).  I've selected the all of the cells except the ones containing 7 record...

Read RepliesRead Related

Retaining the merge of cells even after data import

Posted on Nov 28, 2013 8:33 AM,

Hi Everyone, I have a text file that contains data that looks like this: January January January February February February Value1 Value2 Value3 Value1 Value2 Value3 If I import this to excel it will look just the same, but I wanted to make the months to be shown just once so I edited ...

Read RepliesRead Related

If cell contains certain values merge adjacent cells

Posted on Dec 05, 2013 2:24 AM,

I am a newbie here, so I hope I am posting this correctly and providing enough information about my need. My sheet contains two columns, column A with numbers, column B with text. I want to merge the text in the column B cells if the numbers in column A meet certain criteria. Two examples: ...

Read RepliesRead Related

VBA Merge Multiple Cells

Posted on Dec 21, 2013 8:35 AM,

Hi, I wonder whether someone may be able to help me please. I'm using the code snippet below to merger multiple cells. Code: With Range("J9")         .Range(ActiveCell.Offset(0, 0), ActiveCell.Offset(0, 2)).Merge    ...

Read RepliesRead Related

Mail merge document doesn't print anything except the merged data

Posted on Jan 07, 2014 1:11 AM,

I am printing numbered tickets (10 per page).  I have a mail merge document that includes text boxes and graphics as well as the merge data (numbers 1 - 600).  Everything looks good on the screen but on print preview or print all I get is the merged data.  None of the text boxes or...

Read RepliesRead Related

Excel VBA - Merge adjacent cells from given list of all cells to be merged

Posted on Jan 15, 2014 10:33 AM,

I have a list of cells to be merged. But the list contains different cells, not all necessarily adjacent. I would like to only merge all subsets of adjacent cells seperately. In example this means I have, let say, list of cells: A2, B2, A3, B3, C1, D1. And the script would lead to ...

Read RepliesRead Related

Core Data Cells not updating correctly.

Posted on Feb 12, 2014 4:24 AM,

I have a problem with data being displayed in a UITableViewCell I have created. I have a CoreData Model which I have a custom Cell which I am loading from a Xib. The layout loads correctly and the correct number of cells are generated. The problem comes when updating the button.titleLabel.text and...

Read RepliesRead Related

'Mail merge' data between files

Posted on Feb 21, 2014 12:04 PM,

I am new to this and I am hoping someone can help. I need to use data from one Excel file in another Excel file. What I need is essentially a type of 'mail merge' function, whereby I can set a range to automatically import into the new file. What I need is when I open the file, the program will ...

Read RepliesRead Related

Merge neighboring cells in the same column

Posted on Feb 25, 2014 11:57 AM,

Hi, I am a newbie and would like to write a macro that merges neighboring cells in the same column in such a way: 1) I select a range, say A1:A12, A21:A30, A51:A58 2) The macro does follows i) recognize the range selected ii) merge every two neighboring cells in the range, A1& A...

Read RepliesRead Related

Merge files from a directory in one worksheet and match the data with file names

Posted on Mar 12, 2014 3:12 AM,

Hi all, I have already merge data in different files to one worksheet from the below code. However, I want to match the data with file names displayed in a new column. For example, data in cell A2 and B2 is from file "abc", then I want cell C2 to show"abc" automatically. What can I do? a...

Read RepliesRead Related

Merge cells using EPPlus?

Posted on May 30, 2011 5:12 AM,

I'm using the EPPlus library to read/write Excel files: http://epplus.codeplex.com/ I'm trying to simply merge some cells when writing a document: using (ExcelPackage pck = new ExcelPackage()) { //Create the worksheet ExcelWorksheet ...

Read RepliesRead Related

Compare And Merge Data From Two Different Workbooks

Posted on May 16, 2014 6:06 AM,

So here is the thing. I have a parent spreadsheet with raw data(with errors) and a child spreadsheet without errors. I want to merge the child into parent. (:{). I am thinking of comparing multiple columns from each sheet to ensure maximum accuracy. And when those columns match up we paste...

Read RepliesRead Related

How to merge two cells in excel(both with contents) keeping the formatting intact using VBA?

Posted on Jun 21, 2014 1:59 AM,

I have two cells A1 and A2. I want to merge them and store in A3 keeping the formatting intact. I was able to use the below code to do this. But there is a huge performance issue. Can any one suggest a better solution? Is there a simpler way to do this? Sub Merge_Cells(rngFrom1...

Read RepliesRead Related

How to merge cells using Spreadsheet::WriteExcel using Merge_range function?

Posted on Jul 14, 2010 8:50 AM,

I have used Spreadsheet::WriteExcel for creating spreadsheet report. I tried to merge some cells using merge_range() function. $worksheet->merge_range(3...

Read RepliesRead Related
 
 
Email:

Username:

Password:


Register

Username:

Password:

Login