left()

  1. J

    Using 'Right' and 'Left' formulas - maybe(?)

    Needing to get these 7 digit numbers on their own, thinking it's a combination of the Left and Right formulas Number of characters is not constant so preferably wanting to trigger on the _ (underscores). Any help greatly appreciated <colgroup><col></colgroup><tbody>...
  2. H

    Nested RIGHT function not cutting off "A " or "An " but works for "The " ?

    I'm trying to keep a list of titles in alpha order that disregards opening articles (A, An, The), but will still allow the full title to be displayed in another column. (E.g., "The Addams Family" displays in one, but gets shortened to "Addams Family" in the other.) The display part I've taken...
  3. J

    how do i merge down a sum of formulas into one function

    ok i have written down this =LEFT(A1,3)&MID(A1,FIND(" ",A1)+1,3)&MID(A1, FIND(" ",A1,FIND(" ",A1)+1)+1, 2)&RIGHT(A1,2)&TEXT(MONTH(TODAY()),"00")&RIGHT(YEAR(TODAY()),2) i put these formulas together to generate SKU for my store. I wanna turn this into a function named SKU(), for easy access in...
  4. F

    Extract data within 1 cell

    Hi all I have this data in one cell "L/L Helvatica font 2mg Vit (2ddd)" 1. i just want to exact "Helvatica" , first 3+1 letter space is fixed. i mean before the helvatica 4 letter space will be always there. 2. i want the data within first two spaces "Helvatica" Please help
  5. L

    VBA If Statement not catching all the conditions that match

    I am writing a VBA code to double check and make sure I don't double book instructors or classrooms. My code is below. For each WeekDay/Period combination it checks the schedule and every time a T or R etc and 1 or 2 etc match up with the WeekDay/Period combination I should get a 1. The...

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