strings within cell

Hi Everybody. I'm in a bit of a pickle and i'm hoping someone can help me. The current situation: Our stock dispatcher in the past has been using a spreadsheet that only he understands and even then, the convoluted ways he goes about tracking stock quantities and locations means he doesn't...

Dear All, I am willing to compare two cells according to first one and only show changed values; in example, A1 cell contains a string as: AB, BA, BC, DC, GF, YZ B1 cell contains a string as: AA, DC, BC, BA, GH, JK I am willing to get AA, GH, JK Thanks for any help!

Hello, I have a large number of addresses which have been put into one column. I need to split up the addresses in order to put together a mail merge file. The problem is that there are too many individual words for the normal text to columns function to work eg one address might be c/o Mrs M...

Greetings. I have some dirty data that I need to count. I have a cell that has the following data and I need to count the unique strings in it. The values will be separated by a comma, semicolon or both. I cannot break these values out into multiple columns. The amount of values in the cell...

Hello! Basically what I'm trying to do is the following: First, determine if I'm in the correct row of cells based on the String value of the cell. i.e If the current cell's string value contains the string AB1 or AB2, go through the entire row. Once that has been determined, I would like to...