1. S

    LEN, MID

    Hello, please help, how do you do it if you want to take a character into a number 2, 5 like in the result column? I've tried using if, len, and mid but it doesn't work. Thanks =IF(LEN(A2)=7;MID(A2;3;1);ISBLANK(" "))
  2. M

    Finding value inside a cell, returning it & checking for unique entries

    Hi, I'm trying to sort unique entries in a list of data. Currently I know how to find what I want, which can be done by the following formula: (INT(MID(F8,SEARCH(", ",A2)+2,LEN(A2)-SEARCH(", ",A2)-4) However I want to configure it to find the value in column A and paste it in column C, but...
  3. A

    Using mid/len/left/right/find

    I need excel formulas that will help me differentiate each piece of these cells. Here are examples of the cells Elephant12-8Wb CAT193-45M I already have the formula to get Elephant and CAT on their own. But then I need formulas to get 12 and 193, 8 and 45, and Wb and M on their own. Thank you...
  4. D

    Unable to convert date+time (yy/mm/dd hh:mm) format to excel date

    I have the following column with dates, that I need to convert for excel to recognize them as dates: 21/02/12 15:34 21/02/15 21:18 21/02/17 22:06 21/02/15 21:37 21/02/15 16:05 21/02/17 20:53 21/02/17 00:55 21/02/17 02:34 21/02/19 05:31 I have tried using DATEVALUE, TEXT...
  5. R

    Error during pasting Excel formula consisting of Mid, Len, Search into VBA module

    Hi guys, I'm trying to insert a formula in my code which works in the sheet but not in vba. Running the code below returns a syntax error. I noticed that the errors are due to SEARCH strings containing paratheses for "ENO=" and ",SUB". I've tried changing the paratheses to CHR(34) as well but...
  6. M

    Applying text data to all duplicates found in another column

    Hello, I'm trying to apply a set of comments from column F to column B. I'm unable to change the formatting of column A unfortunately. It would be preferable to have a Vlookup function in column B. Column A will always be variable in length, and column E should always contain the remaining...
  7. R

    Extract more than 2 words into various cells

    I have a string of text in Google Sheets - I would assume is the same formula I can get the first 2 words - but not sure how to expand to get 3rd + In Cell F2 I have typed: (no bold) Wall panels for interior wall FIRST WORD =LEFT(F2; SEARCH(" ";F2;1)-1) SECOND WORD =MID(F2; SEARCH(" ";F2) +...
  8. M

    Count Number of digits 0-9 to the left of a Specific Character in a Cell

    I used a formula to parse a field that typically contains text like the following: 1F5H or 13F1H The following formula works just fine when the number of digits to the left of a given character is static, like 1 numerical digit. However, I'm not sure how to determine how many numerical digits...
  9. J

    LEFT RIGHT combination help. Extracting MID data with many variables.

    So I am dealing with a big project, trying to tear apart written MD orders for reporting. I have hundreds of patients and pull a very long dense report and figured out some of the keys to make it bite size. Take for example the following: right now I am trying to strip out the "50 mg". I've...
  10. J

    Extracting Date from Text

    I am trying to extract a date from text of varying length. Examples: Insulated and 2-Side set by jlee on 8/8/2019 at 3:24:20 PM USACE/White MEP Framing Inspection set by jlee on 8/6/2019 at 6:38:39 PM White Inspection set by jlee on 8/7/2019 at 7:31:10 AM I used the equation...
  11. X

    Area graphs ends on axis mid point

    Hello Excel Gurus, I want the gray area to go through December column rather than stopping on the mid point. Any ideas how to do this neatly? see screenshot: https://ibb.co/qxnwBVv Forever thankful to this amazing community, Xavier
  12. J

    Scientific Notation Removes values when converting cell to Number

    Just recently I've run into this issue. Microsoft® Excel for Office 365 MSO (16.0.11328.20362) 32-bit I process data files that have very long alpha/numeric strings and when bringing into Excel, only certain rows display as 2.1E+61. When i change the cell to number format and no decimal, I...
  13. B

    number separation

    Hi all, I have a situation, wherein i need to separate the below numbers and will be input to other info. 1.5 X 3 X 8 3 X 1.5 X 10 I need to get first numbers-1.5 3 I need to get Mid numbers- 3 1.5 and note there...
  14. Trevor3007

    extract char 5&6

    hi, HR0810919 I only want to extraxct the 'red' text into another cell (char5&6) and prefix with Fl.. Tried, left, right & mid..but no luck:banghead: Does any have the solution for me? MTIA Trevor3007
  15. C

    SUMPRODUCT + MID multiple sheets - not working?

    Hi, Trying to sum multiple columns from another sheet based on one criteria, which is determined by the "MID" function. What is wrong with the formula? 1) B2 (formatted as text)=9132456, 6753456 2) 6753456 appears in D:D (formatted as text as well). It has 100$ in col. P and -10$ in Q. Should...
  16. L

    Using IF and MID together to return "0"

    trying to an IF function along with a MID in extracting numberswithing a string of both text and numbers.<o:p></o:p> PBQ4X5 - using =MID(A2, SEARCH("Q",A2)+1, 1) to returnthe "4" and the same with "X" to return the numberassociated with it. Unfortunately when it runs across a sequence that...
  17. T

    Combining Left, Right and Mid

    I have a column of numbers 8 digits long (text - to display leading zeros). I need to extract digits 2 and 5-8 and place in another column (e.g., 01234567 convert to 14567) or convert the numbers in the existing column. How do I format or combine Left, Right and Mid commands (or is there a...
  18. A

    VBA Help - Saving PDFs with Month/Year then into Outlook

    Hello All - Greetings from Las Vegas, NV, I am new on this message board and am desperately in need of some VBA/Macro Help. Over the last few months, I have been manually saving 30+ PDFs and then emailing them 30 different times through outlook with a different distribution list for each PDF...
  19. C

    CONCATENATE TEXT from the middle of Words & Characters

    Hi all Master, I'm really confused to grab TEXT from words, i already trying used many formula but still <tbody> No. EXAMPLE OF DATA 1 <tbody> XXXXXXX XXXXXXX: 111111_CCCCCCC {SITE NO_111111_BLUE CAR DAYS, SITE NO_111111_RED HOT MOON, SITE NO_111111_THUNDER STORM, SITE NO_111111_GUN...
  20. T

    MID function + not null?

    Hi All, I'm processing camera data on a citizen science platform where each image has to be classified three times before being retired. In this instance, I want to know which are retired, and which are not. Those that are not retired are listed as null in a string, and those that are have a...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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