trailing

  1. R

    STRIM

    STRIM is a complete "space" removal solution to conveniently manage leading, trailing, or all spaces within a string STRIM stands for "space trim". STRIM allows for conveniently specifying what type of spaces to remove form a string. The choices are: leading spaces, trailing spaces, all spaces...
  2. P

    VBA - Remove Leading and Trailing Spaces from a Column in Excel

    Hi Could anybody post a VBA routine to remove LEADING and TRAILING spaces from a Column of Text in Excel please. COL A will do for example purposes. Cant find exactly what I'm looking for on Google. Thanks
  3. B

    Excel remove ONLY trailing carriage returns

    I'm trying to remove only the trailing carriage returns from my data. Sometimes there's 1, sometimes 2 or more. I don't want to remove other line breaks, only the trailing ones. Can anyone kindly assist?
  4. H

    add Trim to VBA code within a macro

    I have several VBA macros which i hopeful of adding only a 'delete leading and trailing spaces' to. i apply the macro to different size files, with different row and column lengths. What i'm after is a code that will apply specifically a 'delete leading and trailing spaces' to what i...
  5. M

    Keep trailing spaces in Power Query

    I use a handy process from Rob Collie's site to find item descriptions that contain certain text. However, the problem is that Power Query strips trailing spaces from my search values. So if I search for "rat " with a space I get "laboratory", "calibrator", and other variations because PQ has...
  6. JenniferMurphy

    Easy way to display non-zero decimal places?

    I have a UDF that calculates the odds for various events. One of the formats it can use for the result is the fractional odds (5:1, 3/4, etc.). I would like to display these in the most compact form possible. That is, no trailing zeroes. Here's some sample data the results I want: <tbody>...
  7. T

    Trailing 3 Months DAX help needed

    Hey there, I'm trying to create a Calculated Measure using OLAP Tools for a pivot whose based is a tabular cube....excel 2016. here is my formula: CALCULATE([Measures].[Sales Revenue USD],DATESINPERIOD('Date'[Date], EOMONTH(LASTDATE( 'Date'[Date]),0),-3, Month)). i'm getting an error...
  8. W

    Need Excel Formula - Removing trailing spaces that doesn't use clean or trim

    I am doing some data comparison/testing and need a way to remove trailing spaces from the end of each cell. The number of spaces at the end could vary depending on the data. Clean/TRIM is removing spaces in the middle that I must retain. I have also trying using SUBSTITUTE to replace but again...
  9. W

    Excel 2010 vba to remove trailing zero from date

    Hi; Ran into a data conversion issue, some dates have a trailing zero behind it, have a few thousand rows affected. Can I use vba to get rid of them, without removing legitimate zeros from the actual dates? Unique values below: 1/1/2007 0 1/1/2010 0 1/1/2013 0 1/1/2014 0 1/1/2015 0 1/1/2016 0...
  10. B

    Remove all Non-Printable characters as well as Clean and Trim; leave name text intact with spaces

    I saw Rick Rothstein's code that removed Non-Printable Characters, and did a Clean and trim as well. Can it be modified to leave spaces in the middle alone? such as, if I have a column of names that may have leading or trailing spaces, or both...Like so: Alfred E. Newman John Paul Jones I'd...
  11. K

    Keep/Bring Back Trailing Zeros

    Hello All! I have a report that I dump from a vendor online. The only option I get is to download it as a CSV file. Sometimes, some of the order information has trailing zeros. The CSV file automatically gets rid of them, but I need the trailing zeros back. This column of order information is...
  12. N

    Keep the trailing zero's in TEXTJOIN

    Greetings again! Is there a way to get TEXTJOIN to keep the trailing zeros when having it pull numbers? I have the reference cells set up to carry out to three decimal places. When I use TEXTJOIN to combine data (text and numbers) it's removing the trailing zeros that I need on my numbers...
  13. D

    VBA macro to add IF(isna( and/or If(iserror( to existing formula

    I'm sure this has been addressed before, but my Google Fu fails me. Sometimes I'll be merrily copying formulae around and notice that some of them return N/A or #DIV/0. I can revise the cells so that the formulae include =if(isna or if(iserror(, as appropriate, but sometimes it's not practical...
  14. P

    Check each delimited value to make sure it meets criteria

    Hello, I have a workbook that has several sheets that have data on them in the following format: 107.75|106.68|96.98 The data can be a single value, or pipe delimited and contain up to 99 instances of values. Is there an easy way to check that each value has the trailing 2 digits after the...
  15. A

    Keep trailing any trailing zeros in formula in vba

    Hello, I was wondering how I can keep my trailing zeros when I reference a cell from one sheet to another sheet in a = text & value & value statement And the numbers of zeros is going to be different so setting it with Fixed isn't going to work, I don't think. I have 2 sheets Sheet1 Sheet2 in...
  16. D

    Remove Trailing Semicolons

    I found the following formula for removing trailing commas on this site: Sub RemoveTrailingCommas_Version1() Dim Cell As Range For Each Cell In Selection Cell.Value = Replace(Replace(RTrim(Replace(Replace(Cell.Value, " ", Chr(1)), ",", " ")), " ", ","), Chr(1), " ") Next End Sub I...
  17. E

    Conditional format for removing trailing and leading spaces.

    Hi, I'm using this formula to remove any trailing or leading spaces. =TRIM(CLEAN(A1)) It works fine but is there anyway that I can use it as a conditional format so that when I paste the information onto the page it removes any trailing or leading spaces. At the moment I have to use this...
  18. B

    Help to remove ; trail from the middle of a string

    Hi, I only find how to remove comma trails from the end of a string in VBA. But i have them in the middle like this. one;two;;;;three;four; how do i clean it in VBA so it looks like this one;two;three;four;
  19. L

    Remove Leading and Trailing Commas, Colons, and Quotes

    Hello. Good day. I am new in excel so I hope you could help me with this.. I have been over the web but I can't find the right solution to my problem.. So given I have a string ,",,abcdef :, ghijk,",:, i want the output string to be abcdef :, ghjk I think this has to do with regex patterns but...
  20. Chris-Tillis

    Cell content involving both trailing and leading zeros

    Hi all, Hope everyone is well. I was wondering if this seemingly impossible requirement is actually possible?!? My girlfriends' a hairdresser, she uses products that have codes such as: 1/1 02/03 20/11 and so on. I thought it might be nice to record these in a spreadsheet, however because...

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