trim function

  1. Z

    Truncate Whole Words within Max Length Set

    Hello, I'm looking for a way to truncate the length of data that I'm pulling from another Sheet using XLOOKUP. ABCD1QuizTitleDataLEN2176888A Funny Thing Happened on the Way to School...xxxxxxxxx463178125A Pirate's Mother Goose (And Other Rhymes)xxxxxxxxx424187860Alexander Hamilton: From Orphan...
    • zero269
    • Thread
    • left function textbefore trim function truncate words xlookup
    • Replies: 3
    • Forum: Excel Questions
  2. brasqo

    =TRIM() within a macro?

    Hello, Hopefully I can explain this without sounding like a dope =/ Quick background, I use the following TRIM() formula on a worksheet column on values that are all similar (IE: ABCDEFG Z307G- Z2CGK / Z307G.... These values could have different lengths, and the below formula seems to work...
  3. M

    Formula which extracts the last two numbers in a cell

    Hi I've got a formula which extracts the last two numbers in a cell and works correct if the cell says 2 for 23 but doesn't if the cell says 2for£23 Does anyone know how to fix this? Please find below sample data which covers cells A1:B3. The formula in cell B2 is...
    • Mr2017
    • Thread
    • 2for£23 cell result right function trim function
    • Replies: 3
    • Forum: Excel Questions
  4. T

    Complicated Nested If statement with 12 conditions and left function

    Hello profs., I am having a long table containing about 20,000 rows (format is in numbers having 15 characters long), I need to get only the first 6 digits in the left for each number and then need to do an if statement with 12 conditions so to map each code with its correspondent company name...
    • Tune4love
    • Thread
    • company left function nested if statement trim function vlookup
    • Replies: 10
    • Forum: Excel Questions

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