excel "multiple strings"

I have the following problem. I need to find a certain word in a string in column B and then copy it to the left cell of the cell. So if there is a word in column B called ""Dog": ""," I need the hole string in column B to copied to column A in the exact same row. Two things maybe to notice...

#Get data "Sheet 1" to "Sheet 2" in excel ( Check in Image , Sheet 1 many Spaces in there , So i Need "invoice Number list" on Sheet 2 (Auto Generated) how to possible get data as a list format, NOTE: SHEET 1 : *** So many Space in there*** SHEET 2...

@ How to match Two condition & show value ???? via formula 1 st table to match 2nd table data , Need Both Condition Match (1) Invoice No. (2) CHA , And Get Result After match 1st table

Hi All, I would like to know how to handle the multiline cell values in Excel. I have a source excel file in the below format. Key Country/State A0001 Australia Sydney Perth A0002 India Tamilnadu Andhra I need the output to be in below format. Key Country State A0001 Australia...

Hi, This is my first thread. I have following the steps to reproduce, my excel sheet column contains a lot of rows like below like 100 to 300's. But the problem is there few white spaces as leading characters which I don't want. I have tried using TRIM() and CLEAN() functions it trims...

I have a large spreadsheet that contains our sales managers initials for all dealer accounts. We have about six sales managers so there are six different sets of initials. Is there a command I can do to change all of the initials to their full name (first, last)? Example change JS to John Smith.

Hi there.. Can anyone solve this riddle for me... i was so confused in this.. hoping for your help... this are the samples "E TIME by 11" IMEI MAC ADDRESS 864436032939937 5C:C3:07:8B:C0:0B calculate in NCK THEH HERE...

Hi everyone, I am working on a project to clean up an excel spreadsheet. I have two columns H & I, that have doctor specialties. I need to run a search in these two columns and find the specific text "Internal medicine" if this value is found, I need to copy that text into Column J. If any...

Hi all experts , i have workbook in which i need to maintain the orders and producer of the product. My Goal: COL C Producer ( if its new product and not enter before in the above COL , then it should auto assign Invoice number in D6,D7,D8 as "ORD#1" , if its 2nd time then "ORD#2" , 3rd time...

Anyone know the formula to pull the filename only and pout it into a cell. Like just the files without the file name extension?

n need of a macro that can create a invoice number in a cell, and save that file with the same name as the invoice number it created. Have about 1300 invoices to create so i would like to make them many copies with each have a different invoice number in numerical order. If you can help that...

Hey needing a way for my company to use the invoice we have created and create a bunch of copies of it and give it its own unique invoice number. The cell the invoice number will be in is I4 i would like it to save each copy as the same name as the invoice number, if thats possible. Or at least...

Hello All, So I have a table which is doing a series of calculations based off of different language criteria. I want to add an additional variable which will only run this string of calculations if another text variable is present in a different cell. If that text variable isn't present...

I have a spread sheet with three columns, column A, column B, column C. Column C has expired dates. What I need is to get an email created with Excel VBA to include in the message the information from the cells from columns A and B. If the Excel VBA module can also take the expired date from...

Need a formula wherein the value which is besides the date is reflected in each cell. In Cell C i have used IF formula. But that formala can't b copy pasted. What i want is highlighted in blue.

Sellers Type of good Amount Company Dave Murray News 99 BBC Jack Anderson Food 123 Sainsbury's Dave Murray Clothes 12222 Gucci Bob Davis Clothes 145 LV Lisa Thompson Food 553 Tesco Jack Anderson Tech 23 TEC Lisa Thompson Tech 99 Netflix Dave Murray Tech...

hello, i would like to ask a question, regarding a problem i've faced recently. I want to take out a specific information from a text, which varies, for example: asdjhbasdas1234BGasdhasd - i want to take out and display just the 1234BG iaiopsunlkas1234BGpiouqws- i want to take out and display...

Dear All; i am facing some problem in counting the numbers actually i have one column and it contain thousands of data both in numbers and in strings/ alphabets. can anyone help me in this regard how i can count only numbers out of it....

Hello Masters, I need help to lookup for a parse of string in a column and return. Let say, I'll use part of the string "Amazon" and look up the value in vendor list below. Thanks.

With VBA is it possible to highlight a row referring a cell in a column having multiple week number in format "W**". for example: column R in below case will have W01, W03 .... I need to highlight only those particular cells. I am stuck with the below format. With Cells...