find specific text

  1. J

    If a cell contains specific text then return a certain value

    Hi guys, Column C C1: AS2_Receiver_AdvancedShipmentNotification C2: AS2_Sender_AdvancedShipmentNotification I have something like the above in my spreadsheet. I need to use the formula to tell me whether it's Receiver or Sender, so I used =IF(C1="Receiver","Receiver","Sender") formula...
    • jjkh58
    • Thread
    • find specific text find text in cell formula return a value
    • Replies: 2
    • Forum: Excel Questions
  2. S

    Need a VBA to identify certain text from one column and enter to another location on worksheet.

    Please help if you can. I have different paragraphs of text in a column. Each paragraph is separated with a blank line. The first words in each paragraph begin with a headline of words that are in bold followed by the rest of the paragraph, which is not in bold. I need a macro or solution that...

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