text & numbers in a cell

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

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

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

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

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

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

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

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?

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

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

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

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

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

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

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?

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

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

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

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

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