text & numbers in a cell

  1. A

    Extracting numbers from text string and including units (mm)

    Hi all! I am working on a project in which I am pulling data from pathology reports regarding skin cancer. The text reports are quite lengthy and contain many numbers (i.e., dates, cancer stage, and the number I am interested in, which is called Breslow thickness). I have managed to use formulas...
  2. H

    Nesting with "does not contain" function

    Hi all, I have a report that I am trying to automate as it just takes far too long to complete it manually. As main reference to edit my data, I have different titles from different jobs which the naming is not consistent. What I want to do, is identify which jobs are not in UK language, and...
  3. A

    Conditional formatting failing in one cell when numbers treated as text

    Hi all I have a SQL back end database, with an Access front end. One of the many things the Access application does is create a report in Excel by taking a SQL view, and exporting it, then doing lots of formatting and generally improving its appearance. The database is designed to record...
  4. O

    Text + SUM of cells decimals error

    I'm working on a break list for my team at work. I want a very simple calculation to count the values in cells and return their number, with the text "currently on break: " in front of it. If I just use =SUM(C4:C16) it works perfect and returns me the number, but using ="Currently on Break...
  5. S

    SUMIFS based on text criteria between selected dates

    =SUMIFS($K$17:$L$1000,$G$17:$G$1000,"win**",$B$17:$B$1000,">="&$R$663,$B$17:$B$1000,"<="&$R$664) K:L range I want to sum in [h]:mm G Text condition B date range. I can select dates in R663 and R664 I have tried the text condition (G) at the end but both returns #VALUE!. Where have I gone...
  6. B

    Mismatch Error w/ REPLACE Function

    Hello, I am working on a macro to edit a fixed width text file. What I want my macro to do is loop through each line of the text file (copy and pasted into column A) and replace a value IF the value of "RecordType" = 1. However, the line with the Replace function returns a mismatch error. Any...
  7. R

    Automatically change number color based on +/- within text string in one cell

    Hello! I have a tried multiple different solutions but have not been able to make this work yet (including trying to write a VBA code) I am trying to change the color or negative numbers to red inside a cell that also contains text/other formulas. This was the latest and what I thought would...
  8. A

    Turning Data in to a 1

    Hi All On m work book I have shifts in put in to cels. Such as 13:00 - 21:00 in one cel. However on another worksheet I want that to show as a 1. So basically when ever numbers are typed in on a sheet I want a 1 to show, However if a word is typed I want a blank cel Can anyone advise?
  9. K

    Inserting Cell Data into Text

    <tbody> A B C 1 Special# Section Title Text 2 50 Title The system shall support [ =A2 ] cycles. 3 70 Title The system shall support [ =A3 ] cycles. </tbody> Hi All, I want to reference the values in cells A2 and A3 in the "Text" column. I would like it so that if I have to change the...
  10. L

    Pivot Table Text instead of Numbers in Values

    Hello Is it possible to get a text instead of a # in the Values section of a pivot table? I have Power Pivot installed because I read that it can help. However I have never used it before and am having a hard time figuring out how to create a pivot table with the data I uploaded (a power...
  11. M

    Match 3 Values & CONCATENATE custom text + Cell Reference

    Hi All, I am working with bar codes of products. Any bar code repeated in specific period is considered redo. For this I have created 4 helper columns which are somewhat fulfilling the need. But I still need to read whole description of work done to specify if it is redo or not. What I am...
  12. A

    Conditional Formatting

    I have a spreadsheet where in Column C the CELLs are filled with a mixture of text and numbers. I am wanting he text to highlight in a colour when text is entered and the numbers to remain black. Example Column C3 has Email typed - This would turn red. Column C4 has a number - 1234 - This...
  13. S

    SUM and Contains Formula

    Hi, Newbie need some help, <tbody> EXTRAS Colour <colgroup><col></colgroup><tbody> 2x25002770, 1xPAD, 1xWindow, 2xInso </tbody> <tbody> Slate Grey </tbody> 1x25005100, 1x25002770, 1xPAD, 1xMotor, 1xWindow <tbody> Mountain Blue </tbody> <tbody> 2x46004100, 2xMotor...
  14. F

    Adding Numbers Surrounded by Text and Special Characters?

    In Column A i have a list of ingredients by percentage: 100% honey 98% sugar, 2% water 50% sugar, 40% flour (going on like that for hundreds of rows) Is there an easy way (formula) that I can have column B return only the numbers from A, added together for a total? For example column B would...
  15. B

    VBA-Adding Text After Number Entry

    I have few cells B12, B18 AND B30 That i would like to enter in a number such as 50 into B12 and then it show 50-Extras Added. Is this something that could be done?
  16. J

    Formula to Search multiple criteria of month/year within a cell and return total numbers from a different cell

    Hi All, I've tried countif using substitute, but I know I'm missing something. I can't figure out how to incorporate counting column B (numbers) if SOME of the text from column A matches column C, provide the total numbers of column B. Ultimately, I would need 8 different text to find. I'm...
  17. H

    Segregation specific numbers from given text or sentense

    Hi Team, I hope anyone can help me on the formula or vba function to segregate the specific logic numbers from the given text ..here I mentioned input data and output and based on logic <tbody> <tbody> Input Data </tbody> <tbody> Output should be </tbody> <tbody> Count of...
  18. H

    Formula to separate number from given line of text data

    Hi All, I hope anyone can help me with below request... I have data with filed called description and which consists of unique PO number and this line item not standard data, every line item which inclusive of special character different different numbers along with PO number. Example Data...
  19. T

    How can I pick text cell every 3 rows

    All my data is in one column. A1:A7785 I have text and number cells. I just need to extract the data every 3 rows (A1,A4,A7,A10...) (A2,A5,A8,A11...) (A3,A6,A9,A12...) to 3 different columns. Thanks for your help
  20. M

    Concatenate Text with Date plus an IF field that will include date

    Hi, I have a start date and an end date. Sometimes the end date is blank. I want the end date to read Pres if there is no date. =""&TEXT(E2,"yyyy")&" - "&IF(F2="","Pres",F2) F2 is the end date - so it part way works: 2005 - Pres if F2 is blank. But if it isn't blank how can I get it to...

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