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

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top