texts

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

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

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

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

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

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

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

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

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

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

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

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

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