texts

  1. X

    Typed text changes cell

    I created simple macros that do the same thing. A text is typed when clicking on a button that runs my macro. I created then a macro to delete the texts that I typed. The texts generated by my macros appear in cells different to those I originally chose when creating my macro. My Excel...
  2. masud8956

    Adding st, nd, rd, th to ranked values

    Hi everyone! I am using the following formula to rank 20 rows of entries at S5:S24. =IF(ISNUMBER(R5),1+COUNTIF($R$5:$R$24,">"&R5),"") What modification do I need to get the texts st, nd, rd, th as ordinal suffix? Regards
  3. F

    How to remove few texts from a cell

    Hi All, How to remove few texts from a cell and list down the values in separate cells Example: 1 of 100 1 of 200 1 of 500 I want to remove the "1 of" from the cell and list down the values in horizontal position one by one as A2 = 100 A3 = 200 A4 = 500 Can anyone please help. Thanks
  4. S

    Return maths anser whereby numbers in A and C and symbol in B

    Is it possible to have Excel do an equation whereby, in Column A you have a number, Column B you have a +, -, *, / etc and in Column C you have another number. I have tried a simple =A1&B1&C1 etc but this only pastes as texts and does not pick it up as if you entered that into a cell So I have ...
  5. A

    Display text/words in pivot table

    Hi i have a pivot table that i need to construct which has a mixture of words and numbers. Under the "Values" section of the pivot table, i have 8 columns of data, 2 of which i need to be shown as texts such as "New" or "Renovation". For the columns which i have numbers for: I can only seem...
  6. S

    if cell contains two different specific texts then return two different values

    im looking for a formula that returns two seperate values based on two different texts in other columns e.g <tbody> £10 £15 Product Cost Windows 10 Windows & Doors 15 Windows 10 </tbody> I then need to be able to sum the total cost Thanks
  7. B

    Applying Color to matching Text in a designation worksheet

    Hello How do I produce the following macro: Find the duplicate texts within the cells of column R in the “Program Logic Models” worksheet that match the exact texts in B5-B94 within the “Impact Matrix” worksheet of the same workbook and apply the same conditional color from the matching record...
  8. A

    Clear the cell contain from one cell if another cell matches starting 4 texts

    Hi All, can any one help me on this i have two columns if column A starting 4 texts match with column B starting 4 texts then clear the contain from cell which is in column A <tbody> <colgroup><col><col></colgroup><tbody> MIAMIFLORIDAUSA088317434 </tbody> <tbody> MIAMI </tbody>...
  9. E

    Is there a way to import images and text from an Excelfile into Powerpoint?

    Hi everyone, I regularly have to make a PowerPoint presentation for my study. Then I have a few dozen PPT pages, where I place texts and accompanying photos. My question: Is there a way how I can import urls or computer location (C: / Desktop .. etc) with photos and texts? The photos in the...
  10. W

    Count distinct (remove duplicate) strings that contains a specific text in an Excel column

    Hi, I have a long list of texts that I need to count how many are distinct (the first occurrence), but only with only contains the word "LOOP" in the text, all the text are in 1 column. I know I can do this with remove duplicates, but I will constantly update the list, so I hope there is a way...
  11. P

    Conditional Formatting For Multiple Columns

    So I'm having an issue getting my formula to work properly. What I'm trying to do: Highlight the cells that are greater than 67% with criteria of engineer, delivery, M/S or other. These are in two separate columns. If I use this...
  12. S

    How to wrap multiple row of text into one cell

    Hi, I try to find solution on the net on how to wrap multiple row of texts into one cell but not able to. Could anyone help. Thanks
  13. R

    Custom Sorting via VBA

    Hi All, I need to sort three columns on a condition that the First column 'B', is sorted in alphabetical ascending order, then column 'C' is sorted based on the texts is contains and finally column 'D' is sorted with the texts it contains. Background on the sheet (only FYI), column 'B' is the...

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