alpha

Good afternoon! I am looking for some help and I don't know if I need a formula or a macro for this... I have a 2-column worksheet In Column A is a product Listing. In Column B is a number listing based on the alpha sort from column A People will be adding products into cell B2. How do I get...

I did a search and think that most of the answers were a tad complex for what I am trying to achieve. I have a number of columns but in one there is an alpha numeric entry. I would like to identify each unique entry and also count how many times each entry appeared and present that in a format...

First of all, thank you all for taking your time to share your expertise. It is appreciated. This is my first time posting, so apologies if I do something wrong. I've read the FAQ, so hopefully I won't!! I have a worksheet that starts with several columns of numeric data that has about 2000...

I need to remove the alpha characters, from an alphanumeric string. An example of what I have, is in column A and the results I want, are in column B. <tbody> A B 1abcd 1 8.2b 8.2 13.12def 13.12 51ef 51 </tbody> Any help is greatly appreciated.

Hello. I am a novice at excel and have spent more time than I'd like to admit searching for a solution to my question. I want to create a fake dataset for two variables and I alos want to calculate Chronbach's alpha (i.e., reliability score) of those items. I need this information because I will...

Morning All, I am after a small favour. Is it possible to create a procedure using Excel 2010 that would search through our folders\directories and list any file that contains data in the format of a National Insurance Number i.e. AANNNNNNA the first 2 digits are alpha characters followed by 6...

Hi, I am trying to split Alpha Numeric data into separate columns but not having any luck. Can someone Help with this. What I would like it to look like <tbody> Reference A30 A 30 A30_1 A _ 1 A30_1_2 A _ 1 _ 2 A_30 A _ 30 A_30_1 A _ 30 _ 1 A_30_1_2 A _ 30 1...

Hello! I have about 10,000 rows of data that I need grouped based on certain criteria and I am trying to figure out a way to group them without doing it manually. Below is the sample data and the groupings I am trying to achieve. Any help is much appreciated! Thanks!!! Total Data <tbody>...

Hi I'm trying to obtain this format TT-T#-T# and I'm using this formula but when I tested it failed to follow the pattern in text and numbers, it only kept the 2 dash 2 dash 2 format...

I am doing a document register where each document starts at Revision A. Once that document is revised, it becomes Revision B, then C, and so on. Once the document is formally approved, the revision number system changes to 0, and when Revision 0 is modified it becomes Revision 1, and so on. Is...

Hi All, I really would appreciate some help with a formula. I am trying to extract 4 characters which will be sitting together in a string, however, the particular 4 characters I am looking for will be sitting as a NUMBER/LETTER/LETTER/NUMBER. For example, from the string below I am trying to...

I have large number of Alpha-numeric values in which i need to lookup other values. For example, the values are sorted from A1A - A1D - How would I make excel to find the value of A1B which is within the range given. Below i Have a sample of the data: Your help is very much appreciated...

I have a spreadsheet that I have to sort by rep name in a certain order so when I subtotal the totals will be in the order I need. I've read about the vlookup, but I'm just not getting how it will work, it seems like from what I read it will put a number by the other columns 1,2,3 etc. but I...

I'm creating a macro that requires user input into pre-defined cell areas. I need only column letters from the user. In the VBA code, I'm screening the input for invalid entries. Rather than write many IF conditions checking for blanks, numeric, length issues, etc. What would be the best...

Hi All I am trying to set up the conditional formatting for a spreadsheet that contains grades achieved against a target value - some students have a target grade over the boundary of 2 grades - for example A/B - so either is "good". Any ideas on how can I format grade cells so that if it...

Hello everyone! I have a large data file with the following type of strings: 13G08 13G09 13G10 18C17 18C18 ... I need to separate into 3 columns (A,B,C) like this: A B C 13 G 08 13 G 09 13 G 10 18 C 17 18 C 18 I know there is probably a good way to do this but I...

I need to remove all the alpha text in a cell using a vba macro. for example, cell A1 reads: " january rate is $.045 " Whereas I would like it to be " $.045 " Thank you in advance