string

dag allemaal :) ik probeer uit een string (boodschappenlijstje) met een formule de bedragen te halen en op te tellen... met een matrix lukt niet omdat het samengevoegde cellen zijn... hoe kan ik uit (bv.) cel AG5 " water 0,75 melk 1,25 chocolade 3,50 brood 1,45 " het totaal in cel AG8 zetten...

Hi, I have a column of date windows formatted as "mm/dd--mm/dd" (so, not in an actual "date" format recognizable by Excel), and I want to use a helper cell to pull the first two numbers from that column, and then another column to pull that number, and return it in "mmm" format. For example...

I attached below some rows I have which you can clearly tell have some weird characters in the text. Is there a formula to find which rows have any of these characters, and which don't. I think that these aren't all of the special characters in the texts, meaning there might be other that I...

Hi friends, the other day, someone posted an issue on the web asking why the statement "i < ActiveSheet.Rows.Count" returns False, in which the variable "i" is declared as a String and is assigned an integer value 3. I have been thinking about this problem for two days and still can't figure out...

Hi everyone and thank you for reading this. I have tried to play around with IF(ISNUMBER(SEARCH... but I did not obtain exactly what I needed. Please, use the pic below as reference. Column D is the input. Column E is the output. Normally I fill in column E manually depending on what is in...

Hi there, Trying to convert text within one cell to a simplified version. For example, I have a cell that reads "UK Fund Mid-Cap Blend" but I want to convert this to "Mid Blend". Right now, I am using the below formula to strip "UK Fund Mid-Cap Blend" down to "Mid-Cap Blend". cell C9...

Hello, I'm trying to create a function called TextByColor using VBA. The purpose of this function is to read through one of my sheets called "JOB CODES" and the return all the cells with a white or yellow cell background to a sheet called "TV". The function should read through all of "JOB...

I want to SUM the numbers in a row which represent the worked hours in a month. The numbers in the cells have a leading string character like V8 or S8 or H7,2. How can I do that. See the mini sheet below for layout and desired results. Thank you very much...

Hello everyone, I am currently working with a sheet that extracts data from a pdf that i upload using queries & connections. the string looks like this in cell B2 B2=IF(LEN(INDIRECT("Page002!C12"))=11,INDIRECT("Page002!C12"), IF(LEN(INDIRECT("Page002!D12"))=11,INDIRECT("Page002!D12")...

Hi all. I have simple question but couldn't solve it. I want to return a Variant array with String data (Variant/String) into sheet, but it keeps being written as numeric in the sheet. I could actually use text conversion function in sheet, but it would be great if the vba could return it as...

have the output in Column A. Want to get COLUMN B and C. How do i do it? A B C apple: RT, banana: TR, banana: DS, apple:PL apple: RT,apple:PL banana: TR, banana: DS need an excel formula

Power Query: I have a column with strings and a list of words I need found in that column AND (this is the difficult part) when found these words need to get cut off from the string (or replaced by "")? How? A sort of textual substraction... have been trying so long... list.accumulate etc...

Remote* Cell values in a named range "MyNamedRange"** have following structure: "U. HeaderName - KeyWord"*** Filters and HeaderName row is in row 10 Objective - Upon Right Click on a cell in above named range: - Filter in Column U using the "KeyWord" * Remote - as in it is not part of the...

Hi, I have the following code which creates an array "Ary" with string elements from a table column that match value "x" from another column in this table. I would like to have cell E6 display a randomly picked string element from this array "Ary". How would I have to alter the VBA code? Sub...

Hello, Column A is filled with string values. Column B is sometimes filled with the value "x". I would like to write VBA code that returns all the string values from column A into an array if they match the "x" value from column B. Anyone knows how to do this? Thanks

Hi, I have a particular software which contain my client user name and it's password along with other misc details like address full name etc. Client password going to expired after every three month. I have sheet which column A contain user name and column b for password. Client password in...

Hello! I tried searching for this in google but it seems I'm being led to something else. I'm writting this formula and need to reference a string that have quotation marks in them. Formula looks like this: =IFS(A2="Yes",0,B2="What he said was: "Mr.Excel.Com" (website)",10) Excel won't let me...

Hi All, I am new to MRExcel and this is my 1st Post. I am looking for a help regarding a mid function. For example :- EBA//92X:RATE:0.99999A://92X:RATE:0.667766B://92X:RATE:9898.18544444A:// I want to extract 0.0667766 in this example but the number can be different for other cases. I open for...

Dear Mr Excel I would be so grateful for some help with this. I have 4 Sheets that contain data that i am trying to write a code for. MessagesSheet (Which is named "replies" followed by "date" and "time"): This contains text messages received. The data is organised as follows: Each row...

Good Afternoon I have a vb statement in my excel macro that I need to dynamically change the workbook sheet just created as the macro loops. the current statement is [Sheet1!A1:J1].Resize(N).Value2 = S after that i have a line that adds a new sheet to the workbook...