string concantenation

My spreadsheet has three checkboxes that users can select from. I want to create a string in one cell based on the checkboxes they select. I need to do this using a formula--no VBA. If they select this: Then the string I want should look like this: SOC2;ISO Multiple values should be separated...

Sorry Everyone, I have data 2 column A, B with 6 rows below: A B text 1A text 1B text 2B text 3B text 2A text 4B text 5B text 3A text 6B I want to run VBA to result: A B text 1A text 1B, text 2B, text 3B text 2A text 4B, text 5B text 3A text 6B Please give me...

Hi all, I am currently stuck on finding a way to input all new changes made to a specific row of cells into a string so that I can parse the final string into another function that drafts out an Outlook message. As there will be continuous updates made to the row, I want to be able to "write"...

Dear all, I have a column in which i have a data in the following format: Name%datetime e.g: John%2018/03/08 19:50 Davis%2018/03/08 19:58 Dawson%2018/03/08 20:05 Now i want to extract just names from these above strings and want to delete the %datetime. Please let me know how i can do this...

Hi all, I have a form that has three fields (1. Comments (TEXT), 2. Legacy_Comments (TEXT), 3, Comment date (DATE)) Now my users need to keep adding comments to the comment text box, and when they do it automatically adds the date they entered the comment in the Comment date box. Now my problem...

Hi everyone: I am using the vba code below to input a formula into excel cells. However, I want to make the "A:A" and the "D3" in the formula relative to the variable c2 (which is an integer). Does anyone know how to do this? Cells(3, 3).Offset(0, c2) = "=IF(COUNTIF(" & "A:A" & "," & "D3" &...