concatenate cells

How to concatenate FIRST SECOND & THIRD name in a single cell separated by a blank. A1: Mark B1: Hu. C1=England Answer: D1: Mark Hu. England

Hi, I have a monthly report which shows our internal tickets and corresponding vendor tickets. Some of our internal tickets may not have a vendor ticket or may have only one vendor ticket, while others will have two or more vendor tickets. I've included a sample of the data below. I want...

Hey all! I have a little problem while trying to use CONCATENATE. Namely. in the first row after data cells, I have random spaces. So after using the function they look like this. Example: abcdfe ______ abbbfff abcdfe ___oilpo freterezlzo_____________________ loaidf So the spaces are in the...

Hello, I would like to concatenate data in Column C (see below) into a single string of text. So, for the data below, I want to read like the following: SHARE:6037138400,SHARE:5500360000,SHARE:6590192700,SHARE:6590180400,SHARE:6037119700, I have over 300 values in the column, so I don't want...

In cells D1, E1, and F1 I have the following dates: Jan-12, Feb-12, and Mar-12. In cells J2, K2, and L2 I have the following formulas: J2 ="Sales $ "&D1 K2 ="Sales $ "&E1 L2 ="Sales $ "&F1 The problem is that the result I'm getting in J2 is NOT "Sales $ Jan-12" but rather...

Excel 2007 Windows XP Hello! I currently have a set of data for the activities of agents for up to 6 weeks of dates. Right now each activity is on its own row. I would like to have only one row for each agent for each date and combine all the activities in on cell with a break after each...

Hi<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> I know that it sounds like an old problem but I still haven’t found anything….<o:p></o:p> <o:p> </o:p> I have four cells in different sheets each having text in different color. I want to...