concatenate ranges

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

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

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

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

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

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

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:="*"...

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

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

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