I have one Excel file
In Column B (275 rows) I have a number (all of these numbers are unique)
In Column C (275 rows) I have a string of text which contains several numbers within the string (all of the text strings are unique)
In Column D (275 rows) I have a different number from...
I am working on a project and need one last piece to wrap up this file.
I have a block of Data B2:N15, There are various formulas within the block that link to other sheets and some manual entry fields. I have set up these blocks so that a user can copy a block and...
I am struggling and need the brains of this forum to help me please.
I am looking for an excel formula that can search multiple columns in a range of data and return an answer in the third column. The difficulty I am having is 1 criteria requires searching for specific text in an email...
I have a list of terms in one sheet (Find List)
I have a column of text data "Replace Data" in another sheet that I need to search for exact full words/phrases in the Find List and if multiple instances exist in the text data of Replace Data, I need to eliminate all instances of that exact/full...
In Excel, I need to pull part numbers from the URLs in a site map. The URLs look something like this:
Newbie here. I've browsed here previously but never posted - I've scoured the internet for potential solutions to this problem but so far have had no joy. Hoping you geniuses can help.
Basically, I have a document I use to ensure transactions between an array of entities are classified...
I have been searching the internet and watching Youtube videos for days trying to create a macro in VBA that will enter a row above a specific text string in a worksheet in Excel. Every worksheet I would perform this macro on has the term "Actual Earnings" somewhere between cells A19 and A22...
I have the following data:
and i need to extract the number portion of the string. My text string will be either 3 or 4 characters long.
If len=4, then left,2. If len=3, then left,1.
I can't make the formula work in excel. Can someone please help?
I tried to extract first 2 words using this =TRIM(RIGHT(A1, FIND(B1",SUBSTITUTE(A1, " ", B1,2)&B1)))
below is the text in ColumnA
A1=Refresh staging database use data pump
C1= =TRIM(RIGHT(A1, FIND(B1",SUBSTITUTE(A1, " ", B1,2)&B1)))
some how did not work
Can anyone let me...
I am in need of a formula or VBA code to achieve the following:
CELL A1: 100,101,102,106,110,111,115,116,117,118,119,120 ---> Output in Cell A2 = 100-102,106,110-111,115-120
Thanks in advance for your help
First time poster, using excel 2007 installed Mrexcel HTML maker, didnt appear in excel, forum tools addin was pasting extra data per the test forums. I am sorry in advance for doing this the hard way.
I have data in the DATA column, and I want to search whats in the LOOKUP...
So I've run into a problem that I believe there is a solution for, however, I am not keen on how to implement the function.
In the chart below you'll notice that all of the FALSE returns highlighted are actually TRUE.
The code is as follows:
I have a column with comments/text string in each cell and I am looking to pull just the date, in the format "DD.MM" using some sort of VBA code. The dates do not always occur at the start of the comment/text string. Sometimes in the middle also.
Is there any way to do this?
OK, so here is what I am looking for. Is there a way to write a VBA code that will search real estate websites for a "keyword" in the property description and if it finds said keyword return the MLS# associated with said property. Why I ask is there are some real estate websites that allow...
A fellow worker sent me a spreadsheet full of cells formatted in such a way that it makes it difficult to remove some of the spaces.
For testing purposes, here's the file:
Uploadfiles.io - remove all spaces.xlsx
In this example, I have this text string in cell A1: " 6403 "
I want to remove...
Hello all and thank you for your help.
I've run into an issue in Excel, and I cannot seem to get any formulas to work. This may be beyond the capabilities of Excel, but here goes.
I need to perform the following functions and return a single value:
1) Search a text string in a single cell to...
Hi. If someone can please give me some advice, that will be grand.
D7:D16 say either "POUND", "PERCENTAGE", OR 'NUMBER'.
E7:E16 say a number ranging between 0.01 and 10000000
I effectively want to code in VBA so that E7:E16 will be formatted corresponding to the adjacent text string.
Looking for a formula to start with below, and return the following. Basically multiplying 6*50, 5*100, 10*100, 12*50, and so on.
CS/6 BX/50 EA
CS/5 BX/100 EA
CS/10 BX/100 EA
CS/12 BX/50 EA
I would check a cell with 2 text rows:
- each row length must be max 25 digits long
- I need a warning or highlight or cell fill in case one row exceed the max length
I have set the data validation to check max length, non considering the row
Could someone help me?