1. T

    Potential Cell Character Limitation causing formula failure

    Hi Everyone, Perhaps I don't understand the separation formula I using well enough, but everything seemed to be working nicely up until data was entered beyond a certain point in a cell. Overall, I am using data imported from another source that is separated by double asterisks between terms...
  2. K

    VBA Code - Trim function

    Hi there, I need some help with the trim function in a code. I have a drop-down validation list in Excel with a 5 or 6 character number, hyphen, then text (see sample list below). I added the following code to the worksheet tab because I want to trim anything from the hyphen to the right...
  3. M

    Extract number with decimal from a text string cell

    Dear All, Appreciate your assistance to my inquiry below. I wanted to extract the highlighted decimal number (put in Column B) from the text string cell (Column A) as below. Anyone can assist on the formula? Source - text string cell in Column A 1/11/21 960 C P GL 71,959.26 71,959.26 CR...
  4. WildBurrow

    VBA to trim cell values for sheet name

    I'm stepping off the porch to play with the big dogs; I'm posting my first question and providing a sample of my code. I am using input message boxes to obtain info that will 1) populate cells on the worksheet, and 2) be used in the naming structure for the worksheet. The issue is that...
  5. R

    Removing Part of Cell/Text

    Hello - Trying to come up with formula that will give me the number from a different cell, but the cell I am trying to reference also had letters, Example: The cell referenced, lets call it A1, contains: '4 yrs'. I would like cell A2 to calculate 4. I tried doing a =LEFT(A1,1), but the issue I...
  6. I

    How to edit this copy and paste VBA code to not use a criteria if not found?

    Hello. I have this copy and paste code that copies cell values from one workbook to another. Copy from pickorder. Paste into wave planner. To match it up it gets the staging location in column D example, "STG.DD35" and the dsp in column E "M5DV." However sometimes this first sheet, referenced as...
  7. C

    Trim, Clean using Evaluate running into 256 character limit

    Hello I have large datasets that I run automated processes on that I need to trim and clean and have been using: Function CleanSheets(arrShtNames As Variant, startRow As Long) Dim ws As Worksheet Dim rng As Range Dim LR As Long, Lc As Long For Each ws In Worksheets(arrShtNames) With ws...
  8. I

    TRIM in VBA on a Range

    i have a range with 6000 rows, i want to apply a worksheet.TRIM function within VBA to eliminate spaces in-between and on the ends... problem is... nothing happens. whats best syntax for this? thanks <code> set rng = range("a1:a6000") With rng .value = WorksheetFunction.Trim(.value) End...
  9. R

    Need Excel Formula to trim spaces before Numbers

    Hi there, Please provide excel formula to trim spaces before numbers, i have received large data that contains spaces in each cell before the amount. I am using MS Office 2010. Thanks, Raaj.
  10. G

    Left Trimming VBA

    I'm struggling to find an easy way to simply trim a range of cells in a column (hard coded into VBA) and then left trimming by a number of my choosing (also hardcoded). I'm looking for something along the lines of this: Range("A1:A10").FormulaR1C1 = "=LEFT(TRIM(R[]C[],9))" But it's not working...
  11. M

    Check first & last letter from 2 columns against a column of words

    Hello, I'd like to check if a word contains matching first/last letters from 2 cells. I can't quite get it to work. In fact, it doesn't work at all - I over sold 'quite'. Eventually I will check MANY words for MANY different first/last matches so I want to automate obviously. Example data...
  12. F

    VBA trim data with space not from spacebar

    I have a two full columns of data that I need to trim. I can see the extra space at the end, but it's not a simple space from the spacebar. This data is downloaded from an Oracle database which as the source, I have no control over. I used =CODE(RIGHT(V2)) to see what the space is and I get...
  13. brasqo

    Trim function on the same cell in multiple sheets

    Hi everyone, Hoping someone could point me in the right direction. I have a worksheet with multiple sheets that are all identical in layout (an export from another program) I need to trim one cell (F12) in each of these sheets. I've used the following formula on a cell to have it trim...
  14. J

    How to compare two set of list with formula

    Hi, How to compare 2 list with find match and mismatch with formula. Can some help me. Sheet4 <thead> E F G H I J </thead><tbody> 1 2 #FFFF00[/URL] "]LED TRIM PANEL LIGHT 5W RD 6500K #FFFF00[/URL] , align: right"]16 #FFFF00[/URL] "]Lts Glannz Solar 1.5w Led #FFFF00[/URL] , align...
  15. G

    VBA - Defining a Range within a Trim

    hi first post - looking for help creating a Trim VBA for a specific range on a worksheet. Range in question is "S2:S200000", on a worksheet called "RAW DATA". Aim of this is to remove extra spacing before and after the text in the cell Have done some digging online and have found some but...
  16. B

    Trim Macro

    Hello guys, I need to write a trim macro. I am using the latest excel. I have an excel sheet with a lot of spaces and tabs wherevar I have data in the cells. I need an excel macro to get rid of those spaces and tabs. Can you help me? I couldn't figure by myself how can I write a trim Macro...
  17. T

    Trim Formula Not Working in Macro

    I appreciate any help on this. Not sure why but the "Trim" formula I'm using in this macro doesn't seem to work. I'm trying to add this formula to the entire column A and it's reading names from column B. Here's what I have: Sub AddFormula() Sheets("Loan_Info").Select Range("A1:A" &...
  18. L

    vba functions are not under application.(dot)

    Hi I wanted to use Trim function (Application.Trim) in my code. So I went to Object Browser and typed Application, thinking that under Application, I will see these functions. Otherwise why it is (Application.trim). But to my surprised, I could not find Trim or other functions under...
  19. L

    Trim in vba

    Hi Trim (VBA function) is not working here. The output message I go is " hello ................ there" Anything wrong with the code below? Thank you so much Sub mytrim() Dim s As String s = Trim(" hello there ")...
  20. M

    How to Trim Once Open Parenthesis Appears

    I have a bunch of cells that I need to trim off everything once and open parenthesis is found, including the open parenthesis Is there a formula that will do this? I have a few examples below The below 3 examples are in A1-A3 Aficio MP C3502( MP C307( IM...
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
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 "".
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