Comparing Strings ..

Mar 30, 2009

I have two string that I want too compare.

String 1 could be something like channel_0_user_defined._system
string 2 could be channel_0_user_defined

I want too compare string2 with string 1 at the left side of string 1.

I don't really know what I should use I found startswith, but vba doesn't have this particular function.

View 12 Replies


Comparing Character Strings In Separate Cells In Excel Spreadsheets?

Apr 1, 2014

I have a large excel spreadsheet with alpha-numeric data. I want to be able to compare two cells in different row side by side and return the difference in another cell.

e.g. I have in cell B2, "tom, rick, mike, I" and in cell C2, "mike, rick". I need to compare the cell C2 to cell B2 and return the difference in cell D2 which in this case would be the characters " tom, I". They are separated with "," and they can be in different order as you can see in the example.

View 2 Replies View Related

Finding Strings In VLookup Value - Embedded In Larger Strings Within Table Array

Dec 20, 2012

I need to do a vlookup that takes a string from one cell and then tries to find that string (embedded in a larger string) in the table array

Essentially I imagine this involves the FIND function at some point.

Attached is an incredibly simplified example of what I'm looking for.

View 9 Replies View Related

Search For Parts Of Strings In Another List Of Strings

Dec 16, 2013

I have an excel worksheet with about 10K rows of data in column A.

I have also another list of data, about 200 rows of data, in column G.

I need to color each cell in column A that contains, anywere in the string, any of the data strings in column G.

in column A
row 1:
row 2:
row 3:
row 4:

in column G:
row 1: help
row 2: info
row 3: support

I need rows 1, 3 and 4 in column A to be colored.

View 9 Replies View Related

Merge Two Strings And Use Them As A Name?

Jan 31, 2010

For example: I want to sort through a a bunch of textboxes and refer them to certain cells. I know I can have a string "TextBox" and then the looping number "nbr" and merge them into for instance TextBox1. But I can't figure out how to use this as a command. Like

View 2 Replies View Related

VBA Sum Different Strings Of Text

Dec 3, 2012

Different formula in different cells give me some text as output, to format this. I would like to copy and paste in one cell, so that I can easily then register a macro on top to wrap the text in one big cell.

View 1 Replies View Related

Inserting A Set Of Strings?

May 4, 2013

I'm trying to insert a set of strings, and for some reason its not going to the next open row, its just inserting them over the last record.


Private Sub Insert_Payment_Click()Dim Payment As String, PaymentAddress As String
Payment = Range("E4")
PaymentAddress = Range("B4")
If Worksheets("RentalDates").Range("I1").Offset("1,0") "" Then


View 1 Replies View Related

Parsing Strings In VBA

Apr 3, 2007

I am trying to parse employee names into seperate string variables in order to display surname, first name and middle name in seperate fields on a form.

The format of the full name is "Surname, First Name, Middle Name (If any)

I have managed to deal with surname and firstname but I am stumped on middle name. Not all employees will have a middle name but for those who do, I need to parse it.

View 9 Replies View Related

Looping Through Strings

Feb 9, 2008

Aside from using arrags, is there a simple way of setting up a loop statement involving words?

View 9 Replies View Related

Strings And Ranges

Oct 7, 2008

I'm getting this weird error which must because I've overlooked some simple thing about formatting (is it called formatting?) my variables.

See, what I think is wrong is that I'm comparing a string with a range and that can make 37 not equal to 37.

Because that is my problem; I have an If statement that compares 2 variables that I know should be the same but the If statement doesnt think so. So to my question; am I on the right track here and if so, how should I tell vba what is a string and what is a range and if I am on the wrong track here;

View 9 Replies View Related

Comparison (Strings)

Jul 28, 2009

I am trying to compare two cells to see if its two values are the same. Some of the cells have a space in between numbers or a symbol like "-"


one cell's value is

and the other cell's value is

the program I have written marks these as different because of the "-" in the second there a way, maybe with a string function to overlook that "-"?

View 9 Replies View Related

Incrementing Strings

Jul 31, 2006

I've got above basic VBA knowledge and learning very quickly (largely due to great forums like this) I'm now creating a userform for the first time. I'm trying to create a New Supplier form and one of the fields is going to be for Supplier ID where it takes the first 6 letters of the Supplier name (entered by the user) & tags on '001' at the end. I've managed to do this but I would like some code to search existing supplier ID's ( Column A on separate sheet) and check whether the ID created already exists and if it does add on '002' instead of '001'.

SO for example..

If user creates a supplier called Microsoft the supplier ID will be Micros001 - this I can do, but if Micros001 already exists then it will generate an ID
Micros002, Micros003 and so on...

View 3 Replies View Related

Two Strings In One Cell

Aug 18, 2006

I have two adjacent strings in a CSV file that I'm importing which were originally intended as a single piece of data. The format of the strings are:

5'-3 3/4" (Yes, it's a good old imperial length measurement)

Right now, I have (5'-3) in one cell, and (3/4") in the next.

I'd like to try to append the second string (3/4") to the first in a single cell. Is there any way for me to do that using VBA?

View 9 Replies View Related

How To Find A Row That Has 2 Or More Strings In Any Cell

Feb 18, 2014

I'm just trying to view the results of this search, I don't need it to make changes to the cells on the bases of this search.

I'm using control + F to open the search box.

It only allows me to type in one single string, such as "Johnson". Problem is, it finds many rows that contain the name Johnson.

So I'd like to further add a number, such as 1.3338, which it can look for in any cell that's on the same ROW where it found Johnson.

It would then return, for example, Row number 81, which has a cell that contains Johnson and another cell that contains 1.3338.

View 3 Replies View Related

Extracting Data Between Two Strings?

Feb 19, 2014

how I can extract data between two strings?

Example: My string is: -_creativename-_spongecell-_creativesize-_300x250-_creativetype-_spongecell-_

How can I create a column that contains everything AFTER 'creativename-_' and before '-_creativesize-_'?

View 11 Replies View Related

Removing Quotes From Strings

May 23, 2014

I have a problem, I have a workbook that is used for importing products on to my website but for the description field it keeps adding the double quotes to the text. this text is HTML code. when I import the products to my website, these quotes show up at the beginning and end of the description. You can't see the quotes in excel but if you copy and paste the cells data in to a text editor you will see the quotes.

My question is how can I remove these? I have removed them in the text editor but as soon as the data goes back in to excel the quotes are automatically inserted again...

View 4 Replies View Related

Replacing Short Strings

Jul 28, 2008

I have a long list of locations in an excel spreadsheet, stating either the country (eg India) or for US locations the state (in a two letter format, eg NY). I need to change all the state location to say "USA". How can I do this, without doing 50 find and replaces? Can I do something based around the fact all the USA locations are two letters, whereas all the others are longer?

View 4 Replies View Related

Counting Partial Strings

Jul 31, 2009

I don't know what's wrong with this it's not working..


i just want to count all the cells from a2 to a20 that has a word "radio" from that cells. Since a2 until a20 have different words like tv power, radio blaster (this should be consider because there's a radio word on it) and so on.

if i use only =COUNTIF(A2:A20,"radio") the word should be exact "radio" and it wont consider the word "radio blaster".

View 3 Replies View Related

Manipulating Text Strings

Jan 12, 2010

I have a column filled with names per row. I wanted to standardize it by using the following format.

The comma after the last name is always an indicator to me that it is the last name.

<First Name> <Middle Initial(if any)> <Last Name>

My actual records contains the following:

Salana, Laura R - need to be arranged to > Laura R Salana
Cantos, Rhoda Grace J - need to be arranged to > Rhoda Grace J Cantos

View 13 Replies View Related

Check Whether String Contains One Of Many Sub-strings

Nov 11, 2010

I'd like to write a formula that check if a string (contained in another cell - say A1) includes at least one occurrence of one of a set of 5 sub strings. If the substring is included then it should return which one.

For istance, say that the cell A1 = " The colour is BLACK" then I'd like a formula in cell B1 that check if any of the following strings is included in A1 (RED, GREEN, BLUE, BLACK, ORANGE) and that tells me which one.

How to do this with a one cell formula ?

View 6 Replies View Related

Counting Strings Across Columns

Jan 9, 2014

I need to get the count of a string from multiple columns. The problem is that string1 exists in column A and String2 can exist in one of eight columns. See the example below.

What I want to do is use two search criteria. I want to find the number of times I have Type=A and if the row has a case Beta. In the example above I should get an answer of 2. (From rows 3 and 9)

I tried countifs but I cant seem to get it working properly.

Attachment 288701

View 3 Replies View Related

Rank Strings And Values?

Feb 22, 2014

Using formula, how do I rank


so it first sorts in alphabetical order using the string before the "-" i.e. CAM27 comes before CAM100, and then by the biggest 'secondary values' (the value after the "-") so that COM98-23 comes before COM98-21?

View 2 Replies View Related

Compare Strings In Two Workbooks

Jan 11, 2007

I have a workbook called Keyword that has two columns c,and d, of words.

The length of the columns can vary,because I add words to them.

I also have a workbook called testfile, and cell B1 has a word in it.

Testfile also has an .xla module that adds in when testfile is open.

I want to type a function called asset in cell C1 of Testfile,and have
it compare each word in Keyword workbook to the word that's in cell B1
of testfile. If a match is found in column C of Keyword, the function
returns the letter C. If match is found in col D of Keyword, it returns
the letter D. If no match, function returns "no match".

I have both workbooks open and the vba code I stuck at the bottom of
the .xla module as another function.

Here's my code so far.

Function asset(Description As Variant) As String 'arg. is the word in cell B1 in testfile

Dim LastRowOfC As Integer, LastRowOfD As Integer
Dim i As Integer

View 11 Replies View Related

Matrix (find Any YES Strings)

May 22, 2008

I have a set of 4 columns with YES/NO statements in them.
I need to find any YES strings, of three or more, within one column, uninterupted by a YES in another colum.

_____A ___B__C__D__E
1 1/1/2008 YES NO NO NO
2 1/2/2008 NO NO YES YES
3 1/3/2008 YES NO NO NO
4 1/4/2008 YES NO NO NO
5 1/5/2008 NO NO NO NO
6 1/6/2008 YES NO NO NO..................

View 4 Replies View Related

Check For New Strings On Another Sheet

Feb 26, 2009

I have 2 sheets of data. I am looking for a macro that will check if there are any strings that exists on Sheet1 but not on Sheet2 and if they do, paste them at the end of Sheet2. All of this data is in Columns A by the way.

View 6 Replies View Related

Assigning Strings To An Array

Apr 22, 2009

My question is about assigning strings to an array.

The following code searches a cell for three strings (said, told, asked):

View 2 Replies View Related

Combining Strings In A Range

Sep 16, 2009

I recently had a query about pulling data from different closed workbooks using a concatenate to easily choose the file:- ....

View 6 Replies View Related

Conditionally Prepend Zero To Strings

Nov 23, 2009

I have a list of numbers that is imported and converted to text. I need to have all these strings beginning with zero "0" except the ones that begin with 1.
To summarize:

If the string's first caracter differs from "0"(zero) and differs from "1"(one) than prepend a "0"(zero). If the first caracter is 0(zero) or 1(one), leave the string as it is.

I am attaching a xls file with 2 columns: Column 1 is how the list is now and Column 2 is how I need it to be.

View 4 Replies View Related

Non-matching Search Strings

Feb 24, 2010

I have a worksheet containing a 'first name' column and a 'last name' column. I've put together a macro that requests a first and last name, then filters on the result, or will filter on the last name only if that is all that is entered (I know this can be done using autofilter, but let's not go there!).

So far so good, but what I want to do is add a bit of code that, when a non-existent last name is entered, displays a message stating this and exits the program rather than trying to filter on the name and displaying no records.

View 4 Replies View Related

Ignoring The Seed Strings???

Apr 28, 2009

Example i import data of say names steve jones, paul jones etc but in some cases it imports (5) steve jones or (db) steve jones and then the lookup wont produce the right data and i get #N/A coming up
so it has
steve jones 10
tom jones 15
(4) steve jones #N/A

i would like to be able to do a vlookup on another tab of that information and just import everything except ( ) and the contents

View 2 Replies View Related

Copyrights 2005-15, All rights reserved