strings

Hi guys, I need your help! I'm creating a Text 2 Win contest where consumers will have to text in a unique 7 digit code to a phone number. How do I create 60,000 unique 7-digit codes in excel? (numbers 0-9)

I have an externally derived and enforced database reference key that uses a mixture of numeric and alpha characters to produce unique strings for database records. So far so good, it does work in their world and in mine other than when I want to check the occurrences of the key, say, in a list...

I need to evaluate a VBA expression in VBA, which sounds easy but I cannot figure it out... Test1 is how I want it to work, I want the Msgbox to display 2 like it does in the Test2-macro. I haven't got any versions of Evaluate to work, Application.Evaluate, ActiveSheet.Evaluate or...

Hi excel gurus! I was wondering if someone could help me with the following: I have a list of words such as Black T Shirt T Shirt Black black t shirt Irrespective of case they are duplicated strings albeit the text being in a different order, is it possible to use excel to group these...

Hi everyone I have written a custom function that takes 2 arguments as strings - when the function is called ordinarily it works absolutely fine. However, when I call it within a double-loop it does not recognise the strings in the cells - I have tested the loop using a counter and know it...

I have coded the price numbers against alphabet below, so if I put price as 9456 in input cell, I should get value AOSP in output cell. Please also keep in mind the ZERO its troubling me in formulas. How can I do this, please help <colgroup><col width="64" span="2" style="width:48pt">...

Hello all, I'm indexing some text files to get some data and pull it into excel. The file format I'm pulling from is a ".txt". The issue I'm running into is when VBA pastes in the string from the data collection. The immediate window using debug.print shows exactly how I want to see my data...

I have a very large spreadsheet containing regional economic data forecasts up until 2100. Economic output is broken down by sector, region, year, scenario etc. I managed to sum the regional output by using the following formula, which sums all 46 rows (for the 46 sectors), returning the...

Hello, Can anyone help with this task I have figures in strange format : 1.500.250,20 which should be 1,500,250.20. Do you know the way to replace points with commas and commas with dots? Ctrl+H replaces all at one go so you either have all points or all commas. But the thing is to have the...

I have a VBA conditional function I hacked together (I'm a noob) that does a hex 'AND" function on a 36-bit value in a cell with another 36-bit value. This result is then passed though another function (total hack) that looks for logical '0' other wise it assumes logic '1'. The second part is...

Help! I'm trying to simply count up the number of opened and closed tickets to tally them up and I can't seem to get my cells referenced correctly. P.S. I've only been coding vba for two days so cut me some slack xD i'm sure it's easy. the sheet is called data and the ticket status is in...

For example I have several text strings text_string_126778 text_string_123456 text_string_234567 I want to sort from position 15 to position 16 Result would be text_string_123456 text_string_234567 text_string_126778 So other than position 15 and 16, the rest I dont care xxxxxxxxxxxxx45x...

Found a few things on here that I thought might do the trick, but haven't been able to find anything that actually works for what I need, so any help would be greatly appreciated! I am trying to match a part of string using Vlookup to an array of known normalized values. For example, I have a...

Hey Excel friends, I cannot seem to figure out how to extract a string between two characters. I need to extract the Department, which is found in the section before gmail.com. I've been trying different combos of find(), len(), substitute(), but can't seem to get it correct! Here are a couple...

Hi All, I'm having trouble pulling a calculated string in another function. I have a table with a list of tests performed in a laboratory. I have created a dynamic (it changes as data changes) list of unique test names. I now want to count the number of each unique test in the data. I'm...

Hello! I am working on a project that is totaling overall values over a certain period, but I am having trouble with the last part, which is finding certain strings in a given range, then counting how many times they appear. For example, I have this range of data in an excel sheet: <tbody>...

After hours of fruitless searching, I've made up my mind to simply post my question. For work-related reasons, I need to take a series of single cells that contain addresses and split them all into 4 or 5 cells: street address, street address 2, city, state, and zip code. I've cobbled together...

Hi guys, I'm having trouble figuring out how to complete this data cleanup: I have a list of items that all follow the same format: 123456789012 Abc company 5 10-04-2013 bcdefgh company y p The items were copied and pasted from a PDF file, hence the messiness, and the misalignment of the...

I have 2 worksheets with lists of strings in each worksheet"validation" <tbody> Wolf Team Bite Back Walk Alone </tbody> Worksheets"data" <tbody> AARDWOLF ABALONE ABACK </tbody> I running some code to test if any word in "Validation" occurs in "Data" and for each occurrence the...

I have just recently discovered the "Split" function and found it very useful for a project I am working on. I am parsing a string in the form of "M71+L09+J82+K99..." with "+" as the delimiter. However, when I try to parse the string into an array it only grabs the strings after the "+" which...