trim

Why not just use the sort function? Because I work with idiots and they'll be using this too. Problem, I can't get blanks spaces to stop appearing and I can't differentiate between two people with the same last name. When I can, I can't tell it to then look at first name to see who goes first...

I am making a spreadsheet that automatically alphabetized as data is input by last name then first name for those that have the same last name, problem is I can't figure out how compare the two. I have helper columns that trim to last name only, and countif <= converts last name into numbers...

Hello. How would I remove all spaces from all column headers in power query with a large table? i.e "Part Number" needs to be "PartNumber" I have succeeded using a small table with 10 columns and 10 rows by: demoting headers transposing the table adding a custom column with...

I'm no coder by a long shot. I found some VBA code on the net years ago, changed it to fit my needs for my MS 2010 Excel spreadsheet. I just recently upgraded to Office 2016 and all of a sudden I'm getting "Compile Errors." "Can't find project or library". This is the code snippet that is...

Hi Guyz, please help me with the below so that i could crack the reconciliation.:confused::warning: Data in one cell of Sheet 1: JASON-JASON BOURNE,SB-America Data in one cell of Sheet 2: JASON I want to search and trim the word before hyphen without any consistency ie. only "JASON" from the...

Hi All, I need some help to acheive triming from the end by the first ">" delimiter from the end in a structure for example: Root > Technology > Photography > Lenses Root > Gifts > Flowers Root > Sports > Clubs > Running Root > Insurance > Car What I would like to acheive is having a...

I am trying to extract a substring from a string that contains a varying number of characters. Example: BLAH BLAH TRN#1#0000000000#9999999999 I would like to identify just the 0's in the example string. I have been using the MID function (below), but the issues is with the number of 0's. It can...

Hello everyone. I have a piece of code that I am trying to simplify. I want to Trim off any leading/trailing spaces and then convert all text to Proper. I want to apply this to the entire sheet. I do not want to have to select a section in order to run the code. This is what I have so far...

I'm trying to match names of companies in one worksheet with another but LEN returns different values. I use trim and still different lengths. What can I use so they match? My goal is to use vlookup or another function to see company rankings on other worksheets. Can anyone provide advisement?

=IF(J22="","",IF(G9="","",IF(D10="","",IF(AND(J22<>G9,G9=D10),"Closing Disclosure Interest Rate does not match Note or ELC Interest Rate",IF(AND(D10<>J22,J22=G9),"ELC interest Rate does not match Closing Disclosure or Note Interest Rate",IF(AND(D10=J22,G9<>D10),"Note Interest Rate does not match...

Hi, Currently i have a lookup that detects a tab name. However the tab names naming convention is First Name Surname Week 1 or First Name Surname Week 2 I just want to have the first name and surname and leave off the Week 2 part. This is the current formula that i use =IF(D2=0...

I have no idea why this happens, I already followed threads from this forum and use the following formulas and macros but still can not get ride of the spaces in front of the cells :( Any help is more than welcome. :rofl: =TRIM(A1) =SUBSTITUTE(A1,CHAR(160),"")...

Hi All, I have come across this cracking macro to quickly iron out extra spaces inputted erroneously by users! The thing is it removes the additional spaces on the Left, Middle & to the Right of the text entry. Can anyone help me interpret these specific parts of macro, bits highlighted in...

First post, hope I'm doing everything correctly...I tried searching this and couldn't find what I needed and I'm in a bit of a hurry, so I hope I explain myself well enough that someone can help quickly. Ok, so here goes: I copied and pasted a table of data from a website - columns have a...

Hello, I found an old thread from 2008 that helped with extracting the 2nd last word from a string of text. However, when I apply it to my situation, it adds the comma that is attached to the word. Is there any way of getting this work without the comma? formula used: =TRIM(LEFT(RIGHT("...

Hello people I got this string "2015-07-22" but I just want to have "07" Could someone help me with a code? Thank you in advance

hi i have many rows , but i saw something strange: when i want to delete all the spaces i want to use "trim" , but its not work here is an examplle : <br> 1<sp>tea when i make "trim" i get - <br> 1<sp>tea how can i delete all the spaces ?

Hello, I have the following situation. I have a column of cells that have the first part of the cell (ID number) separated by a dash but occasionally within the latter part of the cell there exist other dashes in the description. I was wondering how to get the description part that is just...

Hi, I'm copying data between two excel: ... For i=2 to rows_x TEMP_city = ws.Range("B" + CStr(i)).Value 'this value can contains space wsSC.Range("A" & AT_rows).Value = TEMP_city ... next i ... How can I during this process use Trim or Clean function, to delete "space" etc.??

Hello, I need urgent help here and thank you for viewing and probably assist me in my Excel VBA problem. Basically I have a database of sentences within the same cell that: 1)needs to be cut with max of 40 characters (without distorting the words on the 40th character) 2)Slot them back into...