strings

  1. D

    VBA Function that replaces placeholders in a string

    i am currently trying to make a VBA function that replaces placeholders in a string with a value on an excel spreadsheets. I'd like it to be able to take any number of placeholders, for example: {} are not {}. input values for the function: Dogs, Cats Therefore, the function would return ...
  2. G

    How to erase parts of a string of text

    Hi, I have thousands of strings of text like this one in an excel sheet (Pembina Pipeline Corp. 3.54% 02-03-2025 Callable MTN) and what I would like to do is to build a formula that goes through those strings and remove all text to the right of the year in those strings. All strings have 3...
  3. J

    Outputting time correctly when using IF statements

    Hi, i might me missing something simple here but i have the following: =IF($A1="Day1","08:00:00",IF($A1="Day2","09:00:00",0)) Now this outputs as strings which makes it difficult to use in calculations How can i output the 08:00:00 and 09:00:00 as proper time values ? Thanks
  4. M

    Adding Hyphen in Between of Strings Using Macros

    Hello Mates, i want to insert a hyphen in between of strings in the A column. My string format is AA111AA111 BB222BB222,....... A space is separating the strings. Number of strings are dynamic. Hyphen should be inserted exactly middle of the string that is after 5th character. So the result...
  5. D

    Conditonal Format Based On Multiple Strings

    I want to format cells as different colours based on lists of strings. For example: Format cell in MyRange as red if value equals String1 or String2 or String3 Format cell in MyRange as blue if value equals String3 or String4 or String5 Format cell in MyRange as green if value equals...
  6. M

    How to return 'string A' if 'cell range X' contains 'strings B, C, ...' and other strings for other conditions?

    Hello people, So, I have a little experience in programming and (very) little experience with Excel. What I want to do is to have a multiple condition check in a single cell, so it returns one string if a range of cells contains specific other strings, another string if it contains another set...
  7. E

    Extracting Text in Cell

    Hi, I know how to extract text between special characters but my question has a little wrinkle. I have text that looks like the following: 253>9374 734>3949;3948>3448 3847;43548>3949 589 I want to extract the text to the right of the ">". There could be multiple strings in each cell to be...
  8. P

    Strings in formulas for cell references

    I am trying to make the following work in Excel, not VBA. =INDEX('[&A2&.xlsm]&B2&'!$B:$G,5,1) I know I am missing string quotations, but am unsure what else is missing. Does anyone have any input here?
  9. X

    How To Populate Strings Conditionally?

    Dear All, I would like to populate strings based on the SKU & Store combinations. The count of strings will be equal to # SKUs(Unique Count) X # Stores. The strings could go into thousands/lakhs of rows. I have the following sample data set across A1:B5. IN A Column I have 3 Unique Count of SKUs...
  10. J

    Highlight differences between two columns, a1 b1

    Hello, I have two columns each containing hundreds of rows, each cell in the rows contain several alphanumeric strings separated by a comma. What I would like to do is in the first column, column A cell 1 is have excel look at all the data in cell a1 and compare it againest the second column...
  11. S

    VBA - Search for strings then copy strings (+ text up to delimiter) and join in another column

    Can anyone help with this please? :confused: I have a column where cells contain strings separated by the delimiter ';' For each cell, if it contains certain strings I'd like to copy the strings and the associated characters up to the delimiter into column Offset(0,1) or Offset(0,2) depending...
  12. B

    replace Blank Spaces in text string by inserting a comma where there are 2 or more spaces.

    I have many cells with text strings that may contain 2, or more, blank spaces within that cells text. (I don't care about a blank space of 1). each cell may contain multiple instances of these blank spaces. There is no order to the blank spaces, so i need to find the blank spaces and insert a...
  13. S

    Identify Matching Strings in Header Row then Replace characters in those Columns

    Can anyone help with this please: I wish to Find any cells in Rows(1) with the value "To Attribs". Then for each column with this heading, for each cell, to replace specific strings with "" (i.e. delete the strings). In case it is relevant, some of the cells in the columns with the "To...
  14. K

    Cell to only allow certain text strings.

    Hello, I need help with a code that will only allow certain text strings in the cell. So like data validation however not so restricted. For example restrict the cell to have these: Holiday Course Leave But! I would like users to be allowed to enter other information before or after. For...
  15. S

    Text Strings Don't Match - What Can I Investigate?

    Hi All, I've run into a problem where I have two text strings which I believe are the same but they don't match each other (and therefore don't work in index match formulas). I've checked the lengths of both cells and they match so there's no extra spaces etc. I'm no case matching but casing...
  16. S

    How to create a Boolean strings in excel with VBA Macro

    Hi Friends, I tried with a formula creating Boolean strings but its time consuming every time. This is an example: In Column, AI have list of words from A1:A50, It varies every time from A1:A50. ColumnB AND words ColumnC NOT words Here I want to build Boolean strings in ColumnD. In ColumnD...
  17. S

    Reformatting Strings

    I would like to be able to reformat a date string in a workbook. The strings are in the format "15-Feb-08" for instance and I would like to have them read "02/15/2008". How can I use the hyphens as the basis to separate date components and reconstruct the date in a different format? Thanks
  18. R

    VBA Lookup from Table and Replace

    I'm trying to create a function that will function similar to vlookup, but will replace the value instead of return it. The other caveat is there are multiple strings to be searched and replaced within a single cell: <tbody> A B C D E F 1 Lookup Table String Result 2 Chevy A...
  19. R

    VBA Function to Alphabetize Multiple Strings within a Cell

    I have data that is consolidated into single cells. I'd like to alphabetize the strings within the cells they are in: <tbody> Original Data Alphabetized Data Orange,Apple,Banana Apple,Banana,Orange Grape,Apple,Grape,Banana Apple,Grape,Grape,Banana Grape Grape Apple,Orange Apple,Orange...
  20. R

    VBA: Extracting text between 2 strings in a string....

    Hi there, I have a worksheet and in column B, there is a large string (html code): St Withburga Lane, , Dereham , NR19 1EDProject No: DIL029-Dereham-123456Client: Acme Engineering Number of files: 4 In here is an address, project no, client & number of files. I need to extract each of these...

Some videos you may like

This Week's Hot Topics

Top