concatenate ranges

  1. B

    Concatenate Lists of Different Lengths

    Hi All, I have three lists: Column A: 50 state names Column B: List of types of autos (private passenger, light, medium, heavy, extra-heavy) Column C: List of numbers (100, 200, 300, 400, 500, 600, 700, 800, 900, 1000). I want to concatenate the three lists together to create unique...
  2. R

    How to use Concatenate result in Vlookup

    I'm running Excel 2007 I have three related questions here. I have a concatenate: CONCATENATE(ADDRESS(MATCH(TODAY()-1,A:A,0)+1,3),":",ADDRESS(MATCH(TODAY(),A:A,0),6)) that yields a result like: $C$927:$F$1742 but...
  3. E

    variable length concatenation.

    Win XP Professional office 2003 IE 8<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> <o:p> </o:p> Hello I am looking for some help creating a variable length concatenation.<o:p></o:p> <o:p> </o:p> All the data is in column A, the start point...
  4. N

    copy all data from non blank cells

    hello forum, could you please help me with the following chalenge:? i have some data on column L to Y (displayed on rows). i want to copy all data from the rows into cell L. for example: L M N O row1 x y s row2 a 9 row3 row4 v the problem is that i have 70 lines and the...
  5. S

    Concatenate a range but ignore any cell with 0.

    Hi there, I'm concatenating (is that a word?!) a range of data into one cell using the =CONCATENATE function. However, I want the function to ignore and skip any cell which has a '0' in. for example, data: A1= 7 A2= 0 A3= 9 A5 =CONCATENATE(A1,A2,A3) I want to see A5= 79, but have A5= 709
  6. K

    Concatenate 3 columns and retain bold format of contents of 1 column

    Does anyone know a VBA code that can concatenate contents of 3 columns with text cells while retaining the bold format of the contents of 1 column. I have a Range A1:A5 containing text of titles that are in Bold format and I wand to combine it with text of different last names in Range C1:C5...
  7. W

    Concatenate dynamic range

    Hi All, I want to concatenate the text from two separate columns, with a space between the text. The columns are dynamic ranges, but the number of rows will always be the same. The part of the code I'd hoped would do it this are: Dim LR As Long LR = Range("A:Q").Find(what:="*"...
  8. M

    Concatenation looping problem

    Hello All, What a wonderful forum and I am sure this problem will get answered. Ideally, I'd like it solved with equations instead of VB. I have 3 columns (column A, B, and C), each with 3 rows of data in Excel. I would like to concatenate each cell in A with each cell in columns B and C in...
  9. T

    Vlookup

    I have a list of 100 items of data I want to be able to go down the list of items and select the ones that I want. I then want to concatenate the items with a “, “ (comma and a space) between each one I never know how many I will be selecting, it could range from 0 – 30 of the items. I also...
  10. T

    Concatenate Multiple Ranges

    All, I am considered my company's Excel and Access expert, but this problem has me stumped. I have 2 columns of data, as below: Show Name Suffix american idol america's best dance crew series america's got talent show america's prom queen shows bolt...

Some videos you may like

This Week's Hot Topics

  • Problem in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...
Top