extract text

Excel friends, I need to open and close 1000 PDF files, search several texts strings inside each PDF and extract the texts that are located on the right side of each text string, and build a database with the extracted data. More details, these files are NOT PDF forms!. They all have the same...

Hi all, Good afternoon everybody, I am struggling with a problem which involves a column with both the text and nos in that. I want to calculate the following formula. Total = the Sumproduct of the nos in the description*Length*Width*Height. In the description column, 1) The nos will be...

I have a column as named particulars below and my requirements are in columns ahead...plz someone can give me a solution.. Would be grateful…thanks in advance. <tbody> Particulars Look up fields from the column 1 End result required for individual look up...

Hi everyone, A bit of a challenge with this one... The last couple of hours searching have not resulted in a working solution:confused:, so I turn to you. I have 253 cells in column AO that contain text, containing 1 to 6 chunks of text within "double quotes". Here is an example. This is...

Hi, I have text in a cell, a portion of which I want to extract, the form of the text is as follows: ABCD > EFGH (1234) From this I need to extract EFGH, i.e. the text after after > and before ( Please note that the above is a generic example and I have a lot of cells with different values...

Hello there, Our marketing department asked me to assist with SMS responses. Customers (who are clearly not very smart) are asked to SMS their ID Numbers and Names to a short code to enter a competition. The data is a mess. Some have ID numbers first, others last or in the Middle. SOme have...

Hi there, I've been searching for an optimal excel formula that could help me to solve the following problem, but I've been unable to find a right solution yet; so I hope you guys can help me! The example would be: black.blue.red.yellow.green.white I'd like to extract just...

Hi there, I've extracted some lats and longs from Google and want to split them into separate cells and remove the degrees character and direction. Any idea how to do this in one go? e.g. I'd like to convert a whole load of lat/longs in one text string in a cell from this format to this...

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