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

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...

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...

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...

Hello, is it possible to compare two text-strings in Excel? For example, with Fuzzy Lookup I can do put in two strings like this: Eastbourne & Bluebell Railway, 1066 And 1066 and the Bluebell Railway in Eastbourne. This would result in something like a 0.74 match (or 74%) which I would...

Hi, My google-fu is simply not good enough - or what I am trying is simply not possible... Or need some VB code I am not sharp enough to do. I have an Excel document with several sheets - the amount of tabs grows over time, so trying to avoid directly referencing them, but somehow to...

I have a column with data: AB001 AB002 EF001 EF002 EF003 KE001 KE002 KE003 AB003 The formule which gives me the Maximum String in the Strings starting with EF (the result of my formula => EF003) is: ="EF"&TEXT(MAX((--(LEFT(A1:A9,2)="EF")*(RIGHT(A1:A9,3)))),"000") with Ctl+Shift+Enter NOT just...

Hello everyone. I am trying to create a function that runs smoothly. Currently i am using a bunch If/Then statements to return values (about fifty) . The tricky part is i need to return strings from numbers. For instance if the value is 1 return apple. The issue i am having is the keys are not...

Hello, I'm looking for a way (excel formula) to compare two text strings and return what's in common between the two. All the information is in one column so i will apply the formula in the column next to it and copy the formula down to the other rows. <colgroup><col width="237"...

I have a column of text strings in Column E and I would like to have a formula in column F that returns only the text strings that are seven characters in length. If they are shorter or longer than seven characters then I would want the cells in Column F to be blank. Would I do this via an IF...

Here is the Sample that I will be referencing: https://www.dropbox.com/s/qsnzojulgipugma/Test.xlsm?dl=0 In this financial planner, I have data in sheet one that gets moved over to sheet 2. When this happens, it auto updates the text to remove all the repeating data. (card number). I have made...

I am stuck with a VBA code and badly need your help. Here's what I am trying to achieve - Step 1 : I have to iteratively capture strings in column D (the count of which is mentioned in C2 which will change depending on the data set) - Done Step 2 : Each of these strings will be split based on...

I had an Excel file, perforce, where I wanted to identify the cells containing formulas. I recalled the ISFORMULA function. I used the ISFORMULA function in tandem with an IF function and FORMULATEXT to reproduce the formulas in the respective cells. The complication occurs in that the...

I need to somehow search nine columns, each containing one text string, some preceded by #. The text strings I collect in a list. So I would need the solution to reference my list of text strings. The correct result would show only the text strings in my list, found in the nine columns. It may...

Hi all, I'm improving a macro and want to save the file according to the current naming conventions used. The files report numbers used for the current day and the day before, so the file names take the form "REVIEWED_07172018_07182018_TQREPORT.xlsx". I can get today's date into the string...

I have three lists: > LIST 1 is a set of substrings that need to be removed from the main list - LIST 2. The substrings are either a prefix or a suffix (either the beginning or end of one of the strings in LIST 2). > LIST 2, as mentioned, is the main list that needs to have one of the...

How do I add an item to a drop down box ? I know how to (with a loop) to get the individual items (strings) but I dont know how to add them. thanks in advance Al

Hello! I have a Workbook that is updated every week with a list, in column A on Sheet1. I want to go through the Sheet1 list one cell at a time, and look for matches in Sheet2, column A, and copy the text from that cell on Sheet2 into column B for the current row in Sheet1. The Sheet1 strings...

Hi, I'd like to create a string of 6 random consonants (e.g., "kftryp") but with 2 caveats: 1. no letter repeats (e.g., you can't have "kftryk") 2. the string does not contain a consonant that is used in another specified cell (e.g., if the specified cell - A1 - contains "tiger" then "kftryp"...

Apologies if this is a "newb" question, but Power Query is completely new to me and I've no idea how to go about this... I have a text file which is data dump from our email client and contains almost a million rows, most of which I don't actually need for the report I'm creating. The data is...