right funtion

  1. T

    Excel Right Function Dilemma

    Hi all, I have a confusion with using RIGHT function. I need to create a complicated formula that depending on two digits after comma. I’ve used RIGHT function to do it but the step that you can see below, the result seems like isn’t true. I'm sharing formula with the sample values(not cellIDs...
    • trndlr
    • Thread
    • right formula right function right funtion right() right() not working
    • Replies: 3
    • Forum: Excel Questions
  2. P

    Split unformatted addresses into separate columns

    Hello Excel experts, This is my first post here. I need your help in solving an issue with separating out addresses into address, city, state and pin code. This is how my data looks now. <tbody> <colgroup><col></colgroup><tbody> 503, LEVEL 5 , BLOCK A KELANA CENTRE POINT 3, JALAN SS 7/19...
  3. F

    how to combine left, right or mid function

    Hi, how can I read/select the number from the string as below: for example: A1: = "Audi A6, Poland - N123323 - SG" A2: = "VW Polo, Denmark - (X) - N233217 CN" A3: = "Ford Fiesta, Italy, XZ, (new) - N876233 - WW" I wan to have only: B1 = 123323 B2 = 233217 B3 = 876233
    • Forestq
    • Thread
    • left function mid function right funtion trim text
    • Replies: 6
    • Forum: Excel Questions
  4. A

    Figuring out the right funtion

    I amhaving an issue coming up with an accurate formula for the situation i have below: i have 3 categories 0-20,21-45 and 46-65. i have another two columnssaying where the patient is coming from (Hospital, LCHSA or outpatient) and theamount of hours are required per pateint. I am looking for a...

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