excel "multiple strings"

I have data in a single cell in the below format 1 NULL 384 JPY 0 2 2 384 555 JPY 0 10 3 555 389 JPY 0 128 4 389 1000 JPY 0 2345 I want to split the data into different columns Like for example C1 C2 C3 C4 C5 C6 C7 C8 C9 0 384 555 389 1000 2 10 128 2345 CAn...

I want to add multiple lines in an excel column. Please suggest the ways? <tbody> Line 1 Line 2 Line 3 </tbody> For now, to do this, I first write is in a Word document and then paste it in Excel file.

I’m trying to create an attendance workbook with each sheet being the month, with multiple rows/column. I have created a drop down list to choose from on a different worksheet. What I need is the following; HVX and HVP can only be used if HV has been used in the cell before. If D is used then...

I have data like - shi007yyyy_1_2 ggfdf_dsdjskhd777_v_2 hdjshdjs_1_kkkkkkkkds I am looking for a formula to get the biggest word out of the data- So the answer i am looking for should be - shi007yyyy dsdjskhd777 kkkkkkkkds Left,Right & mid works but i have lots of data and i cannot change...

Hi Everyone, I hope you're all doing fine. I need your help to get the correct formula for the #ofPaymentsMade and the NextPaymentSchedule. Below is sample table. I hope some can help me on this. <tbody> Start Date End Date Duration Payment Term # of Payments Made Next Payment Schedule...

I want my formula to say if this =this and that=that then x=y here's what I have: =IF('2015 WORK'!U29=DAILY!A137,FALSE)*AND(IF('2015 WORK'!E29=DAILY!$A$134,FALSE)*'if(false,2015 WORK'!A29=DAILY!N137) I don't know what I'm doing wrong, well I can see several things wrong with this one, but I...

Hello, I am working on a project where I need to split hours between departments. So for example if a shift was done from 7am to 7pm it would be coded to the department in Department 1 (column A). If it was worked from 7pm to 7am it would be coded to the department in Department 2 (column B)...

I am trying to format the following formula but am not sure how to do it. In sentence form, I'm trying to say: If column/row C59=Tom and column/row G59=**** and Column/row K59=Harry, then column/row R59 =1 or 0 if false. =IF(AND(C59="Tom"*G59="****"*K59="Harry"),1,0) Additionally, what I'd...

Hi All: I have certain info in one column as below. I'd like to use a formula that would show me only the 4 last numbers if it has the format CC - xxxx (see in bold below). For those that don't have the same format (in red), they should remain the same. (What I did was: For the first 3 rows...

Hello kind people :):):) I would love a VB 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 racking my brain on this problem, and I can’t help but think there must be a better solution. I am trying to create a formula that counts the number of facilities that have findings in each of the areas (There are 80+ areas) :confused::banghead::help: I am trying to put together an excel...

Looking at the headers below I want to build a look up formula that will result in the latest (most recent date in list) transaction date (A) for a specific transaction type (B) for the MedID (D) for Station (E) and return the associated information in the desired results format listed below the...

A-B A-C A-D A-E B-C B-D B-E C-D C-E D-E GENE1 0 0 1 1 1 0 1 0 1 1 GENE2 1 0 1 1 1 1 0 1 1 0 GENE3 1 0 0 0 1 1...

Hi all, I ve a small query. I need to generate a list of all possible two word combinations from a list in excel containing two columns first name and last name. the first name itself or the last name can be a combination of two or more words. thats why I need a list of all possible two word...

I'M STUCK WITH A PROBLEM. NEED HELP. THERE ARE TWO SHEETS SHEET 1 <tbody> main cust code linked cust code name balance in account A balance in account B 123526 50456 ABC 1012 2045 123526 50455 DEF 2564 89787 123526 85456 GHI 4564 4897 123526 123526 JKL 7874 4454645 </tbody>...

How do I use an Excel formula to find which (if any) multiple sets, each of up to 50 words, exist in a series of rows of a spreadsheet — if set A has one or more words found in a searched cell. A positive result will return a specific value in the designated result cell. If none of the words...