concatenating

  1. M

    VBA for Concatenating Cells in a Specified order found in a list

    Hello all, I have this code so far, for concatenating values in a range: Function Concatenatecells(ConcatArea As Range) As String For Each n In ConcatArea: nn = IIf(n = "", nn & "", nn & n & ","): Next Concatenatecells = Left(nn, Len(nn) - 1) End Function Assuming I have this data: How...
  2. M

    super-scripting text when concatenating text

    How to insert superscript in concatenating text as given below. ="ΣH= ½ WH2 = ½ x 1x " & E171 & "2 = " output : Regards, ~M
  3. N

    Tiny question about concatenating the following...

    Public SaveName as String Set y = Workbooks.Open("C:\A\B\C\ & SaveName & ".xlsx") Very small question please...how does one get around the "period" when concatenating the above? Because the above returns an error because of it. Thank you :)
  4. N

    Concatenate Cells based on Dynamic criteria

    I am looking to write a formula that can concatenate cell A$1$ (absolute) & B1: B245 (dynamic)and then A$2$- B1:B245 and then so on. So for example, I need to concatenate cell A$1$ & B1, and then A$1$ & B2, all the way up until B245, and then I need to restart the sequence with A2 and B1...
  5. S

    Inserting text into another text string

    Ok, so I am very close to this and probably just need a pointer or two... What I am using: Excel for Mac 2011 What I Have: 300 rows of html text, exported from a website, that contain product titles What I am trying to do: Insert the word "Lenses" before the word "for" for each row. For...
  6. S

    Concatenate two strings but format text differently

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

    Preserving Superscript when using CONCATENATE

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

    Sticky: Watchrange, Concatenate date to existing cell value

    Hey everyone. This one is a little tricky in cell B, data could be entered but isn't always. BUT - If someone were to type in a cell in col B, then I need today's date to be concatenated on to the end of whatever they type in there. If there is nothing typed, I'd like it to stay blank...
  9. D

    Concatenate

    Not sure if its a duplicate post. I want to achieve something like this:<HTML><HEAD><Script Langage JavaScript><!---function ViewSource() {var HtmlSource;HtmlSource = document.all.ForSubmit.innerHTML;HtmlSource = RetDeleted(HtmlSource);document.write('<HTML><BODY...
  10. T

    concatenating textboxes into label

    I need to combine 7 textboxes into 1 label. I have tried the following code but it only combines the first 2 boxes. I dont understand why it wont do all 7. Im putting this code in private sub textbox1_change label1.caption = textbox1.text & textbox2.text & textbox3.text....(and so on until...
  11. T

    concatenating textboxes into label

    Alright I've got some help from this once before and it only worked to an extent. I've got 7 differnent textboxes that when filled out make a combinded statement in a Label box. It doesnt make a complete paragragh but it would be nice to have either commmas or some seperating marks like ***. I...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top