trim text

Good day new to this community. I've been trying to use the following formula to have data on the LEFT of the same CELL to clean it and use it to VLOOK up another sheet and brining in a code. Formula: = VLOOKUP(LEFT(H4,(FIND("V.",TRIM(SUBSTITUTE(H4,CHAR(160),CHAR(32))))-2)),'Vlookup...

As part of an Excel macro, I'm trying to find if a string has a specific word in it and then, if it does, copy the string to another cell without some of the words in the cell. I've tried this (below) which works ok, BUT if the address you see below is not EXACTLY the same which is often the...

Hi gurus, I've read many posts on various forum to solve the problems on the leading space(or space-like stuff), but after trying many functions, including Trim(), Trim(Clean()),Code(Left()), and other ways, I still cannot get rid of it... Originally I pasted these from a word document, and...

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...

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...

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...

i have a data in cell a1 need to remove space by count lenth and remove the space 321321 23132 2 2 2 1 2 is the right time to talk 3213212313222212 is the right time to talk out put latter 16 from left and remove space in between

I am looking for a formula that can convert (###) ###-#### to ##########. Basically I have phone numbers in the common format in column A and want to remove all non-numbers without using a VBA script. Any ideas are welcome. Thanks in advance.

Hello, Excel semi-noob here, I have a vlookup issue that has been driving me crazy. I am working from a sheet (in workbook A) that has a list of usernames in column E. These usernames also exist in column B of Workbook B but they contain an extra five or six charactes at the end of the string...

Excel 2007 Windows 8 Hi all, For this project i need to analyze clusters of data. My first step is to remove all none duplicates. I have created this formula =COUNTIF(N:N,N1)=1, this goes all the way down to =COUNTIF(N:N,N5443)=1. My plan is to remove all rows that return a "True" to delete...

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

I am trying to write a macro that filters a list based on criteria in a particular column and transfers the information to another sheet. There is a problem with the line xmitter_type = Application.Right(Trim(Cells(j + 2, 5)), 1) within the overall procedure of: Dim cell As Range Dim...

I have been stymied with an INDIRECT function issue and feel like I am very close to resolution, but need assistance from an expert. My workbook has a Summary worksheet that needs to pull from specific cell references in subsequent worksheets. The following formula works if the worksheet name...

Hey, This should be really ez for most of you... I have a text xyz-XYZ. where xyz can be any text. How can get the text string on the left before - and also how can get the text string on the right after -. End results should look like this Cell A1 xyz Cell B1 XYZ Kind Regards,