concaatenate

Hi Guys, I am stuck trying to concatenate 2 numbers cells, retaining the number format - is there anyway to do this or does excel always convert the concat to text? Example of what I am trying to do: In one column I have a mixture of 4 digit and 5 digit numbers. All of these need to be 5...

I have a cell that looks up an account number and returns what row it is in. (B2) but, the data I am looking for is below and a few columns over, so I need to use an offset command to get the data. =OFFSET(data!F22,1,0) this works just fine. the problem is that I need to copy this command...

Hi all, I have been reading quite a few posts on this and haven’t managed to find what will work for me, - Several post talking about using VBA, but unfortunately as I’m sharing the document so this wouldn't be ideal (many won’t accept macros), - Several talking about a...

Hello All, I am Not a excel genius. I am trying to make a file in which i canauto fill information of employee on one single page. I have one file (Workbook 1)which has 52 tab (Each weekending Sunday). I want to make a formula in which if i put week ending and Employee number it gives me...

hi, how to write CONCATENATE function to connect 3 fields (AM, AN, AO). For i = 5 To x_ws1_rows ws1.Range("AK" & i).Value = ws1.Range("AG" & i).Value day1 = Day(ws1.Range("AK" & i).Value) ws1.Range("AM" & i).Value = day1 month1 =...

Excel 2007 How do I make a multiple conditional formula have the ability to active/deactivate a certain condition dynamically. The example below should clarify; I have the following formula: =SUMPRODUCT((Building=$B15)*(Unit_Type=$B16)*(Unit_Line=H15),Rent_Month_Total) This formula sums the...

I work for a church food bank that calls groups of people. they need a better way to display and track what random group numbers are called and how many families are served every day. im trying to make this easier because they are manuall entering this into notepad on an overhead projector and...

Hi, I am looking for a VB script to concatenate 3 columns as below: A B C abhimanyu Nagpal ECE The output i want in A1 would be a single string with comma in the end of value from column C. Cell B1 and C1 values get deleted. A B...

Must be 2007 compatible. I have a table with more than 50 columns and over 3,000 rows. I need users to update multiple columns of data with valid values. Each cells needs to offer different dropdowns based on their values. Let me try to explain: NameRanges: USA_Prefix (all of the...