extract content of cell

Hello! I need help with a project in Excel. I have multiple cells with large amounts of text and numbers. I need to extract the listed identified time and the verified time and then calculate the turnaround time. Here's an example of the data in the cell: EXAM: CT Head w/o Contrast CLINICAL...

Hello everyone, Big fan of the Mr. Excel forum, and first time posting. Thanks in advance for any advice! A small nonprofit that I am helping gave me a dataset that tracks their donations and I am trying to clean it up for them so we can run analytics. However, the dates for each row (1 row...

I have a cells that contain Names and Dashes ex: "Aaron Arbogust -- John SMith -- Bret Johnson -- Dan Bologna" I would like that to extract all Upper case letters and Dashes to read:"AA--JSM--BJ--DB" Basically extract Uppers and Dashes OR remove Lowercase letters and spaces

Hello, We have large files that require we change customers 7 digit call forwarding number to a new 10 digit number (adding an area code). I have tried severl formulas but so far no luck. Example: CWT DGT PIC 0222 Y CFDA N NSCR 1 A 24 FIXRING 5936245 CFBL N NSCR 1 A In this example I would...

Hello everyone i have assigned a task in the office , i already know the vba code to send mail via outlook and i knew everything is predefined inside the vba code (TO,CC,BCC ,SUBJECT and and BODY).but the issue now is i need to create a userform with combox and extract the value selected in...

Formula Challenge! This one is out of my league. For an ASAP work project, I need to extract an a physical address (including multiple spaces) from a single cell, with two different (but same) delimiters on either side, and drop into new columns. See example below. I've tried two different...

I converted a text file to 2007excel file. There was a cell containing this: =-CLASS FURNITURE Excel will show it as #NAME? I need to extract this text "CLASS FURNITURE" so as to concatenate it with adjacent cells (to get a vendor name). I tried many functions (right, text, substitute,..) to no...