concat

  1. T

    CONCAT only IF spesific cells contain spesific words/names!

    HeyI've tried to make a formula but can't get it to happend. I use a formula to count words/names and it works fine:=SUM(COUNTIFS(C63:C72,{"*Mike*","*Peter*","*Jane*","*Even*","*Jack*"}))But my problem is that beside counting the words then I also neet to have the types beside.Eks; cell A1...
  2. G

    CONCAT Help

    How do I use the below formula to output a percentage of F10 instead of a decimal? Also, is there a way to automatically make it + or - depending on an increase or ad decrease of growth?
  3. mreinsmith

    Create Formula from another Formula - Nesting Concatenate Concat

    I've often wanted to look up if it was possible to concatenate the results of a column of concatenate formulas (of course, CONCAT only starting in Excel 2016) I thought maybe there would be a function like "FUNCTIONTEXT" but "FUNCTIONVALUE" So I started looking and I can't seem to find...
  4. G

    Concatenate and retain formatting

    Hi, I have a spreadsheet that auto imports data and then does further calculations. In cell A1 I have a date/time value in format dd/mm/yyyy hh:mm:ss I have chopped this using the formula =int(A2) in cell K2 with the format dd/mm/yyyy and determined the day using the formula =weekday(K2) in...
  5. R

    Adding/combining cell text to a web address and displaying as a hyperlink

    Good Morning, I am new to programming and looking to make this code below even more user friendly. Right now the user has to double click on the cell to get the VBA to take the cell information and plug it into the URL based on criteria in the code. Is there a way to have the VBA run through...
  6. E

    Can someone explain union , Const and

    Hello people, Could someone explain following terms/declarations or whatever you call it: Const Union Concat Chr I did read some on Microsoft website but I didnt understood. Could someone help me? Thank you in advance
  7. C

    Finding Duplicate Values using VBA

    Hi, I have a question I'm hoping to get help with! I have multiple columns / rows of data, some of which are duplicates. Column S is a concat of columns A:R where this data is stored, and is sorted alphabetically. I'm looking for a way using VBA to find duplicate concat rows by cycling...
  8. The_Rock

    VBA for Remove & Concat

    Hi Folks I hope you can help with writing vba for the following. I have 3 columns: Location Oppt Status UK1 JS001 Approved UK1 JS002 Pending NLD1 GS001 Approved NLD1 GS002 Rejected NLD1 GS003 Rejected What I...
  9. N

    VBA: Concat loop with Formatting

    Hi, i'm looking for a solution to the following. I have a table like this: <table border="0" cellpadding="0" cellspacing="0" width="128"><colgroup><col style="width:48pt" width="64"> <col style="width:48pt" width="64"> </colgroup><tbody><tr style="height:12.75pt" height="17"> <td...
  10. J

    Help for a newbie!!

    I've just signed up and i hope somebody can help me out. I'm tryin to write a macro that will: - find the condition columns in a spreadsheet (their headings are coloured light turquoise) - check if each is populated - if it is then copy each individual cell's info and the column name,(e.g...
  11. P

    Lookup Question

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

    if B2 blank, append B1 to A1

    My starting data: 15-25mm | bob 1/2-1 | 15-25mm | john 1/2-1 | tony 15-25mm | craig 1/2-1 | If a cell in B col is blank, I wish to: 1) append the contents of B1 to A1 inside brackets 2) delete the row that had a blank value in col B Data above should end up like this: 15-25mm (1/2-1) | bob...

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