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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top