characters

Hello, This on has me baffled and I tried everything I could think of. Longstory short, I'm working with an old windows program that extracts data into anexcel worksheet. There are a ton of rows,but many are useless (like headers, totals, other stuff) Anyway, I did discover that the data I...

I have a template for journal entries that I need to get into a different format. Right now I'm writing formulas that are working, but I cannot drag down so I'm thinking there might be a vba solution. There are 6 columns, B:G, account, center, debit, credit, company, plant. account and center...

Hey all, I have a sheet where I insert data each day and I want to generate a monthly overview. The Formula in the cell says: =IF(COUNTIF(Sheet11!$CKO13:$CTT13;E$2)=0;"";COUNTIF(Sheet11!$CKO13:$CTT13;E$2)) I want to change the characters in red color according to a certain month to later...

I hope someone can assist with this question. I require to understand the number of characters behind the final '\' character. Example: Monday\Tuesday\Wednesday Answer in next cell = 14 (14 characters behind the final '\') Or is a possible solution to count where the final '\' is in a...

Hello everybody. dim code as string I have a string composed by 1474 characters. When I define code = "..........................................." part of the string - located in the belove row - is red. I suspect a maximum length for the string variable. Isn't it?

I have a line graph in Excel on Mac. The size and location of the labels on the axis change based on the width of the characters included. Wider labels get slightly smaller and move up higher. Smaller labels remain larger and stay on the bottom. These are all the same number of characters...

Field contains 1990NorcrossRoad I need 1990Norcross Road

Hello, Forum, I am unable to find a VBA which would select cells which contain specific characters in a range. Could some give a hand? Thank you for taking the time.

Hi all, I've read a fair bit about special characters, ASCII code, code/char functions etc. in Excel but still have a couple of understanding questions where I was hoping someone could shed a little light on them or point me to a direction for further reading: (using the num keypad only): - In...

Hello again, Earlier I asked for some help in extracting the last name of the employee in the string of characters listed below. The help was excellent and the formula below works perfectly. Now I've run up against another issue with this string. I now need to extract the 3 numbers to the...

HI all, I have just joined as i have spent the last hour unsuccessfully searching the net trying to sort out an excel question i have, what i'm trying to do seems pretty simple but i cant figure out how to do it... I'm a basic excel user, using it mainly to create pricelists. So here is the...

Hi, My code I currently have... =IF(OFFSET(A8,0,1)=OFFSET(A8,-1,1),OFFSET(A8,-1,0),OFFSET(A8,-1,0)+1) Basically if the value in the cell next to it is the same as the one above then the value of the cell the formula is in, it'll be the same number correlating to the one above... Makes it...

1. The webmaster needs to code a control in the "Tags" field that COUNTS the number of characters being used up and display the number of characters dynamically AS WE TYPE to help us optimize the words we choose when creating a NEW Post. Also, switch the characters to the color RED when we've...

Good day all, I'm trying to chop off 9 characters starting from the left in a cell, when I use the "LEFT FUNCTION" excel returns the 9 characters chopped off. But I want excel to chop off 9 characters from the left and returns the remaining characters to the right. However, I...

Hi I have a simple lookup: =IF(ISNA(VLOOKUP(B183,'Sheet2'!A:T,20,FALSE)),"",VLOOKUP(B183,'Sheet2'!A:T,20,FALSE)) However, the result (i.e. the data in Col T had 9 characters, but I need the lookup to only display the first 8 characters. Is there a way to do this? Thanks Paul

Hi I am hoping someone can help. Looking for a formula to use on a large excel sheet to rearrange the characters in a specific order. The following is an example. "1f6f33b9-35bc-6d4b-8377-ca5fc024eae1" to change to "b9336f1f-bc35-4b6d-8377-ca5fc024eae1" Basically the first set of 8 characters...

I have a worksheet where column A contains the file names and Column C contains the number of characters in the filename. I need move all files that have a name with 32 characters (including .pdf) If the file name is greater or less than 32 characters then send an email.

How to shorten the length of the words in excel, Foreg. if i have words of 50 characters and i want to shrink it to 25 , is there any formula to do so?

Hello, I have this table and I am looking for a cooler way to use it as a guide and create an algorithm from it. So from the table, 1 is assigned to A, J and S. So say a word like “KELLY”, I want to add up all the characters by using their number value. That’s “Kelly” = 2+5+3+3+7 = 20. Then I...

Hi guys, I need a help with the Pivot Table please, I need to group text fields automatically by the first 3 characters, how could I do that? Noting that I need to do this in the same workbook because I came across some solution but it needed to create new workbook for the Pivot Table. I do not...