text string

Hi This might be a simple question but I'm stumped & would appreciate some advice. I have over 4000 rows of text data that will need multiple manipulations & filtering but require a running total of visible rows only. This data is not in numerical format so subtotals & count formulas do not...

I have a text string that I need to make multiple extractions from. I've managed to make use of MID & FIND in extracting what I want, only I'm getting too much. How do I delete the remainder of the text? Text string...

Hi! So I have been pulling my hair our trying to figure out how to build a VBA for a process that is so time consuming and repetitive and deadly. background: I have hundreds of records of customer info and I am trying to categorize the job titles so that I can conduct some analysis with a...

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

I have a mapping program that uploads data with the date and time but when it exports it the time is converted to just a number string, e.g. 15:12:37 becomes 151237000. Is there way to eliminate the last three zeros and insert a ":" between the second and third, and fourth and fifth characters?

Hello Everyone, I have a single text string of names from Outlook seperated by a semi-colon that are in one cell in excel. I am looking for a formula to seperate those 30 plus names into seperate cells. Does anyone have a formula that will do that? eg: John Smith; Jane Doe; John Doe; Jane...

I'm stumped, I have a cell value that is an address with leading numeric characters varying in length. I need to figure out how to either extract the leading numeric characters or insert a comma where the numeric characters end and the text string begins so I can do text to column and seperate...

I would love a <acronym title="vBulletin">VB</acronym> code or something or some sort to help me with this problem, its a very important task for me. How can I find a certain text string in a PDF file (located in a certain drive) and either pull the text from the .pdf and put it in a cell, or...

I am trying to figure out a way to quickly count how many keywords are in a cell, based on a list of keywords that I will have to add to/subtract from in the future. Here is an example: Let's say I have text that reads the following: "Alpha, bravo, charlie, delta, echo, foxtrot, golf, alpha...

Hi all, after searching all through the forums and posts I could not find a solution to the following problem: I have 2 columns ,A and B, in a table and text strings in C. Each table row A1 and B1 needs to be compared and matched with the text string C:C. Only if both, A1 and B1, are found in...

Hi Excel fans, I'm puzzling over a problem, and I hope you guys can help. Can you think of a way to do the following... Suppose I'm a grocer and I use a spreadsheet to track my inventory. I sell fruits, vegetables, and dried spices. On one worksheet in my Excel file, I create the...

Im using Excel 2007 & Windows 7. I do not have any programing or VBA experience. I have managed to be able to find when the "Unique Text String" is present in a "Longer Text String" by using the function =SEARCH(TRIM(D3),TRIM(A3)). The "Longer Text String" varies in length & sometimes contains...

I have a text strings in Coumn A that have a variable name length. The names are seperated by a comma and the the 1st hyphen. I need to extract the first and lst names before the first hyphen. Ideas?? A1 Fitzgerald, Tom-L2,SRT(MSP) - out 5:00 A2 Smith, Steven-L3,OBT(OSP) - out 3:10 thanks, Kip

Say I have these two lines in Column A: 3051S2TG4A2A11X5AWA3WK1I5A1140 3051S2LD2AA1A1030DFF71CA00 I need to be able to have a formula in Column B that Finds the letter "A" when it is followed by four numbers, and then return "A and the 4 numbers." So for the first line, the result in Column...

Hello, [I apologize upfront for the length of this, I wanted to give all the detail I could think of] I am trying to automate my data extraction to support income tax prep where I end up with all the data I need on one Excel worksheet for filling out HR Block or Turbo Tax I am hoping there is a...

I have phone scripts that can be built from 6 different categories. Each of the 6 categories has anywhere from 1 to 11 different scripts within them. I want to generate every possible script from these options, i.e: Part I: "Hi, as of 8am, on march 20th" Part II: "our records indicate 2...

Hi everyone, I'm scratching my head as to how to resolve the problem of extracting text from a cell into a number of separate cells and I'm hoping you good people can help! In cell A1, I have a lengthy text string separated by a number of asterisks ("**") and I need to separate the text...

I have a column of cells, each with a with text string that has three possible formats where I want to extract the total number of seconds. The three formats are: nnn hrs nn min nn sec (example: 1 hrs 42 min 58 sec) or nn min nn sec (example: 55 min 1 sec) or nn sec (example: 10 sec) The...

I have a cell with the value Western Washington University - 516 High St. - Bellingham, WA 98225 ( in bold ). in this text string i have a university name, street address, city, state abv. and zip. I need to extract each individual value in to its own cell, the format of the text string...

Hi, I'm totally new to posting but have found MrExcel a life saver on more than one occasion. I would like to count the number of times a name appears given month and year. For example, Mark appears twice in july in 2010. My spreadsheet is as follows: A B...