slash

I have this textbox that I want it to hold this kind of text format: "12345678" or "ABC/1234/12" Now these are the conditions I want to validate: 1. If I start with a number, then accept only numbers and stop registering any key stroke when the length of the textbox reaches 8 characters 2...

Here are the sample text: Input: 1. AbST/1234342 2. Y_sRR/666 3. B.RE/1234 Output: 1. AST 2. YRR 3. BRE Basically I need a formula to get the first three capital letters before the slash and disregard lowercase and symbols.

what's the vba code to remove any character after the last "" in a string?

Hi All I am using this format 1.1.1 and I want to change it to 1-1-1. I figured this would be easy to do with find and replace. I am using the latest version of Excel for Mac. The problem is that when I type in the dash (-) to replace the (.), Excel takes it upon itself to use slash (/)...

HI, I need to create a Excel Database file for work and more importantly I am really terrible at Excel. I need rows from 1-1000 and only 1 column - that much I know....but it has to be 1000 records of "1/1000" then "2/1000" then 3/1000 and so on all the way to "1000/1000". So far all i am...

Hello, I join a series of two cells together with a slash in between, such that the cell shows the two numbers as a fraction, such as below: C1=A1&"/"&B1 I'm wondering if it's possible to have the numerator be displayed in bold font, while the slash and the denominator are in regular font...

Dears, Another question... I've to collect 2 information that is CAR and TYPE, and the user can insert it in different ways, like: BMW BMW/SEDAN /SEDAN So, everything before the slash is the CAR and after the slash is the TYPE. I'm trying tho use the expression Split, but when there is...

Hi, everybody. I have numbers like a/b, formatted as text, and I need to sum separately the numbers before the slash (a) and separately the numbers behind the slash (b) to get a result in the same a/b format. Example: 1/2 + 7/1 = 8/3. I have created a formula that works, but has problem with...

Is there a way where I can limited a userform textbox to only allow the following to be entered a-z A-Z 0-9 Full Stop . Comma , Forward Slash / Backward Slash \ Minus - Single Space With a msgbox popping up if any other value is entered. My code that I have brings up an error message but...

HI, forgive what may be a stupid question, but I have a supplier that sends me a massive sheet with one particular column that contains the following type entry. 2 / 9 or 4 / 11 etc with value on either side of the slash varying. I need to apply a formula the can differentiate and interpret the...

Wondering if any of you have others experienced the following... 3-4 years ago, while using imported dates from a database in Excel 2003 (or maybe 2010 - can't remember) I realized that some of my dates were not calculating. I checked their properties - Excel said they were in fact dates. I...

I am trying to lookup a value in a separate workbook whose value contains a forward slash. The lookup value is "Total Disc / Coup" and the lookup doesn't work with the forward slash in it. Here's formula: =VLOOKUP("Total Disc / Coup",'C:\FH276 QB WEEKLY...

I J K L M (NOPQ) R S T U V W X Y Ordered Product...

I have a formula that works but I don't know how to read the formula: =+LOOKUP(2,1/($AZ$2:INDIRECT("AZ"&ROW())<>0)) What the heck is that slash after the 1 in the second argument? What does it do? I can't find any examples with a slash like this in them...