parsing

Hello All, I am working on a statistics project that I could really use some help on. In short, I need to analyze data from a given website to draw the academic conclusions. The second caveat is that I'm extremely new (and extremely green) about using VBA so I'm not particularly familiar...

Thinking through a problem here and thought I would elicit thoughts from the board. I have a few thousand emails saved as text files. [For the sake of the problem, they are all saved in .txt format]. The issue is that the emails are often chains where the recepient/sender/dates/subject can...

I have 100 worksheets from a doctor's office. Each row is data from a patient visit. Each cell in a row contains string data about the patient (name, blood pressure, etc.) as well as the date of the exam, diagnositcs, etc. I want to create 100 new worksheets, but with some fairly basic...

Hi Everyone, First of all, you guys are all awesome. I've learned a lot just from searching other stuff. I do some computational biophysics research but am having trouble with some of the data processing because I need bits of information that are nestled inside large strings of text. Here's...

I am new to this site and drsarao's work on this thread was awesome: http://www.mrexcel.com/forum/showthread.php?t=424754&page=3 I tried to PM him, but no reply. I have a cemetery spreadsheet that I need to work on (hobby) and I need to parse the names (50,000 names). If I give you some...

I need formulas in the PosX PosY and PosZ columns that parse the number in column B. Notice the value in column B is a formula. The formulas in Cols C thru D could reference the original data which lies on another sheet. Excel...

I do a lot of spreadsheets where the original may have a set up like this Column A: James Doe Jr Jonathan Doe Jr I need it set up with the first name in the first column and the last name and Jr put into the second column. I have tried text to columns but it puts each part of the name as...