character

Hello folks, here is what I am trying to do. I have a column of numbers like this: 091215421R And I need each cell in the column to be formatted like this: Q09-1215421 There are always 10 characters in the original cell. The last character may be anything but needs to be dropped. A...

Hi Friends, Here is the data and what I am trying to extract I want to extract words like Hexadecimal to character" which is abbreviated as X2C I am able to extract text between characters "(" AND ")" but not full meaning/form of abbreviated word. Hexadecimal to character (X2C) is a...

Hey all, I'm making a spreadsheet for the users on my Discord server, so they can identify fanartists who accept commissions, and calculate which prices they want. https://docs.google.com/spreadsheets/d/1skPQhzpjgW2dogUINUCV47Pv-TBFdcKxdZ9NsMdjObY/edit?usp=sharing I'm providing a google...

I need something like this =ISNUMBER(FIND("*","!",P6)) that if a cell contain any specific special character return true or false. For example, if the cell contain any other character than a number or letter it will return a true or false.

Guys I felt I was close to getting this one but I gave up. In column D I have a column of product IDs. I want in cell A1 a formula that counts the number of times that "8" appears as the 7th character in each product id in column D (from D1:D100) would suffice. The product IDs look like this...

I have a data file containing data from several different countries, many of which use accented characters in their alphabets. The file has been unable to interpret many of these and replaced them a black diamond with a white question mark inside: � On my PC (Office Professional 2013), I can...

Hi and thanks in advance to whoever would like to take on this task. Please bear with me as English is not my first language, I will try to be as clear as possible. I would be very grateful if you could help me in this query. I would like to count the occurrance of the character S as shown...

Are you a human?:Enter the number of days in the month of January I was met with this question upon registering, yet it would not allow me to enter "=EOMONTH(1/1,0)" as the character limit is 3. Perhaps the character limit should be extended when = is the first character? :) Cheers, Jon

Hello Guys, I need help with vba to remove the last character from a cell if that last character is non-numeric text. Eg. 7a would become 7 and KJUA9a would become KJUA9 etc. Thanks in advance.

Hi all How would I remove everything before a lower case character In column M I have starting at M10:60 example 3263 7 h 3502U- 10 ht 445334 11 t 35-409 6 3-355P 7 w 1 v 936423 7 120-PP 9 7-0565 4 /34303 9 h 1 P78062 8 75566F 4 b /34-PU 8 t would leave h ht t blank cell w...

I can't seem to figure this out -- any help would be greatly appreciated. I'm trying to validate a column in my excel workbook with the following criteria: Length of 9 characters Each character must be a number The first character may be '0'. The field itself should remain a text field. So...

I am working too hard manually. Trying to do a string that will give me the character in the middle between two characters. I need to do a count between / and /// <colgroup><col width="365" style="width: 274pt; mso-width-source: userset; mso-width-alt: 13348;"> <tbody>...

I'm trying to adapt a function that currently uses Range.Characters and replace it with something that can be done in array. I had some ideas but it doesn't appear they were feasible. I did have one thought that I think is doable but I need some direction. I pose my myriad of questions here...

Hi All, I'm trying to use a formula to find the first alpha character from the right of a string. For example, from the below, I'd expect "C" returned. <colgroup><col width="161" style="width: 121pt; mso-width-source: userset; mso-width-alt: 5888;"> <tbody> BABA US 09/21/18 C165...

Hi, I have a Vlookup the fails because it appears that Excel thinks the () are different characters. Is there anyway to handle this? Thanks.

wb.Worksheets(1).Columns("K").NumberFormat = "_("$"* #,##0.00_);_("$"* (#,##0.00);_("$"* "-"??_);_(@_)" when i am using the above line to apply number format i am getting error saying that $ is invalid character, i don't understand why can someone help?

Hi, we are trying to clean some data up & extract text which ends: 883;" from search strings... EG we would like to extract 2N5883 out of cell B2 = ;XYZ12;2N5883;B73304001;B73304;;;;;;;; The plan is to use the MID function with a helper column: a) SEARCH("883;",B2)+3 to find the...

I hope that this is is not too dopey a question. I receive a sheet of 1000 plus records frequently where in column A each record is part of an English post code with an asterisk at the end like AB1• or KT32*. However many characters there is always a * character. I would like to be able to...

Hello there I have written a wee program to extract the contents of a cell one character at a time and write them to the Immediate window along with the character position and the ASCII value. The purpose of this code is to determine what any invisible characters in the cell are. At the start...

I'm getting lots of help from the Forum with trying to help a friend with his data (imported into Excel, and messy). Many thanks. The main elements have been dealt with, but I need to flag up the cells where problems may still exist. The 'cleaned up so far data' is in col C, mainly text based...