text strings

Hi there, I am seeking to eliminate the "False" value from being returned within a fairly complex formula that is located in column AC. I believe that this "False" is due to the 2nd condition in the formula. All the text strings are hard-coded in the existing inventory system, and cannot be...

I'm trying to SUMIF numbers in one column if text strings in an adjoining column contain specific text. For instance, if Column A contains a series of text string like this: COLUMN A A2: some text etc. other text SEARCH-VALUE more text, even more text, etc. A3: another string SEARCH-VALUE more...

It seems to be a huge challenge for Excel VBA to format inconsistent text strings and so I am looking for a solution to format the following table: The table may contain hundreads of rows that have to be manually checked and so it is important to make it as readable as possible...

I am trying to find a method in which to detect 2 separate Text Strings within a given cell. In a nutshell - user input on a form I have is not always what it could be. So, if the expected answer would be "No Luck," some users will invariably enter "No Luck." Unfortunately, according to...

Greetings! I have the following text string in cell H in my spreadsheet. I need a formula that can remove the bold part numbers from within the text string. As you can see they are all different sizes. <colgroup><col></colgroup><tbody> Out For Rebuild - Qty:1 / 227-9850 - PUMP GP-AUXILIARY...

Hey all, I have a table that contains a list of reservations and a table that contains a list of "BOMS" (bill of materials). I would like to count the number of times a BOM shows up in the reservation table in a specific fiscal year. An example of each table: <tbody> BOMID FY2010 FY2011 1...

Hi I have a list of names on tab Y of a spreadsheet which are all 10 characters long and I want Excel to do the following on a different tab (tab X): Where I enter a matching string of 10 characters in the first column of tab X, populate the adjacent cell to the right with either 'Y' (if the...

Hello, Many thanks in advance for your guidance and help! I have a column (Column L below) which has several texts in many rows. I would like Excel to search for the following text strings from this column (Table, Chair, Desks, Cabinets) and if any of these are found then return the same text...

HI everyone I need to search two columns for a text string, and return a 'yes' or 'no'. The challenge I have is that the data is entered by a number of different people and they use a combination of lower and uppercase letters. Currently I have this (thanks to a little worki on Google)...

I'm copying a PeopleSoft department tree into Excel. For those unfamiliar, it is a grouping of departments similar to a file structure where certain departments roll up into other nodes (folders) that all eventually roll up to the ultimate parent node (folder). When pasting this into Excel...

Hi all, I have a form that has three fields (1. Comments (TEXT), 2. Legacy_Comments (TEXT), 3, Comment date (DATE)) Now my users need to keep adding comments to the comment text box, and when they do it automatically adds the date they entered the comment in the Comment date box. Now my problem...

Hi, I'm trying to find the difference between two dates however the dates the I currently have are text strings. I have about 25,000 rows so wondering if theres a way to convert this into a date I can manipulate. Also, I'd to make the dates PST. This is how it looks exactly in my spreadsheet...

Hello, I have a list of text strings and I'm looking to only return 5 digit numbers from them. They vary in length and position and sometimes there are numbers that are longer than 5 digits (I don't want these). Is there a formula that might work for doing this Here is an Example. I want the...

Hello, I have recently upgraded from Windows XP/Excel 2003 to Windows 7/Excel 2010. I have a file comparison utility that takes in pipe-delimited text files, compares them, and then allows me to select and copy the "rows" of delimited text that show up in the comparison viewer and then paste...

Hello everyone, I hope the title is not too confusing, but I couldn't think of what else to put. I am trying to string together several cells to create a machine nut description. I have a spreadsheet with several columns (thread diameter, pitch, locking/non-locking, etc). I need a cell with a...

Not sure I can articulate this correctly. I have two columns (on different worksheets) that have names. In this example below, all the lines would be a match because at least one 4-letter string in each row matches. (Having any name match is enough, do not need to match all names.) What I"m...

I have an excel assignment due tonight at midnight. I am stuck on this one question before i can move on. In cell D3, enter a reference to the value in B7. Format the cell to display the text string Interest Rate. In D3 i entered =B7 and the value for B7 popped up in cell D3, I am confused on...

Hi All. Fairly simple one this. I think I'm dealing with a bug in excel 2007 - I'm doing this replace sequence in vba across a sheet with many instances of the character to replace, the sheet includes some cells with large strings of text. Here's my code: ActiveSheet.Cells.Replace What:="§§"...

Is there a way to create a calculated field from two text strings and a literal? I have "LastName", "FirstName" as fields in the Excel 2010 database and wish to have a "Names" field that will display "Smith, John", for example. I thought that since there is a place for a formula that I could...

I have a userform that shows the results of many values in 20 text strings such as: textlabel1= "firstname1 & " " & lastname1 & " " & housenumber1 & " " & street name1" textlabel2= "firstname2 & " " & lastname2 & " " & housenumber2 & " " & street name2" I want to set the text lengths of ...