concatenation

Hello everyone, I would like help with displaying a number as dollars and cents in a concatenation formula. My current formula is ="Location 1 "&Sum(G5:G13). This prints the location and the sum of the those cells, but the number looks like 32437.31 instead of $32,437.31. Can...

Hi, I currently have an excel file containing parts with a few characteristics : -----A----------B-----------C--------------D-------------E Part type----1rst letter----2nd letter----1rst number-----Name --Valve---------D------------V-------------0-----------DV0001...

I'd like to concatenate two text strings but format each part differently, like this: cell A1: Title cell B1: Subtitle Concatenate in cell C1 as: Title Subtitle The source cells (A1 & B1) are unformatted. Easy to figure out the concatenation itself, but I don't know how to do the formatting...

Hi! I need to concatenate two columns of data which are selected by the user. So the macro searches through the column headings to locate the required columns and then will concatenate them. I'm able perform this task by running a loop through all the rows of data. The problem however is that...

I have a list of stock symbols (many hundreds) indexed in row A:A of an Excel worksheet, eg: AQT BSI CMXO DOD ESTA I need to merge the list into one cell with a comma (without any space) between the tickers, eg. AQT,BSI,CMXO,DOD,ESTA Any help would be appreciated.

Hi, Trying to CONCATENATE 2 text columns, (A1 -AX & B1 - BX), column A has a single superscript character in the middle of the word, i.e. xxxx2xxxx , where the 2 superscript. The column B has no formatting to preserve. I have found the following link with VBA code to assist, but can't seem to...

I'm trying to populate fields in a (transactional) workbook based on data from a named range in another workbook (master data). I've successfully done this in the past by specifically defining the file and range name in the master data workbook in a VLOOKUP (but I'm looking for a more generic...

This formula r1c1 stuff is like voodoo. There has to be documentation of it soemwhere. Anyway, here's my question: Why doesn't the computer like this? Worksheets("QOutput").Cells(x, y).FormulaR1C1 = "=SUMIF('R'!c[5]:c[5],QOutput!r[x]c[1]&'Q','R'!c[y+11]:c[y+11])" Since the only way I can...

I have a need to concatentate several worksheet pages to wite a single PDF. I have been successfully doing this (using CutePDF as writer) for a long time. Today, it is trying to write the pages one at a time. I had to merge some pages in manually from another worksheet into this file, which is...

Over the last few years, I've tried to do something in Excel. I optimistically survey the documentation for the function(s) I need, but I always walk away defeated. Can someone tell me how to do the following? I have a table with two columns: Data1.........Data2 ------------- --------------...