characters

I am currently trying to figure out a way to extract a name from a cell with a different types of data. Specifically, the employee's name that will appear after the statement "Employee (NUMBER): " and the employee's name is obviously different lengths of characters. The current formula I am...

Hi - hoping some expert can help me with a text search query I've got a column full of text entries. What I would like to do is extract x number of characters after certain keywords. So for example. keyword 'DOB: ' then bring back the next 10 characters So if the below is the text in cell...

Is there a formula or conditional format you can use to extract and string from a cell where the string is always a certain number of characters. I have a spreadsheet where the cell includes the VIN for an auto but the VIN is always 17 characters long. The problem is there are other items in...

I have a large set of data that contains SKUs with different number of characters. Each SKU can range from 10-20 characters. The only thing that is constant is the last 4 characters. Which formula can i use to only replace the 4th character from the right? Example SKU1-U-101 SKUUU-U-101...

Thanks for taking the time to read. I have a list of surnames in Column A and first names in column B and I need to combine the two into one cell which I can easily do by joining strings. However I also need the format changed with characters adding so: from this: Smith John to his: Smith...

I have a column that is basically a description field. It may or may not contain both invalid characters, and hidden, or non-printable characters. I want to use regular expression to remove the invalid characters and replace them with " " (a space). so for example a-z, A-Z 0-9 are acceptable all...

I've seen a few things around for something similar, but I'm starting to wonder if this is possible... I formula that finds the last filled cell in range "A". That cell contains the following text "DEV-19-1". I need to increment the last digit (will eventually be 2 digits), but ignore the...

How can I convert my excel spreadsheet from these strange characters into words and numbers?

Hello All, I'm looking for efficiency so a formula or VBA will work for this. I'm trying to find the best way to create a title that is as close to 80 characters as possible So the title is broken down like this Quantity - Color1 - Brand1 - Size1 - Style1 - Pattern1 - Size2 - Brand2 -...

Hi, Need to autofill the characters ONLY with a number value staying the same. example. E48A E48B E48C etc. through "Z" without the letters I and O thank you and God bless, Craig

Hi, I am struggling to get a satisfactory method of doing this and fromgoogling it, it seems to be due to a suspected bug in Excel but I haven't beenable to find anything that provides any help with my specific requirement. I am using Excel 2010 which is what we're constrained to at work...

Is there a formula that can be used to remove printable hexadecimal characters from a cell? It appears that CLEAN only removes non printable characters. I am trying to load data into a business system from an excel template and it is erroring on Hex characters so I was hoping there was an easy...

Good Day I have the following VB code that generates a 10 character alphanumeric password. This code works perfectly fine. However I would like to change the code to include special characters in the password. The characters are limited to !@#$&* [CODE]Sub TenCharPassword() Dim i As...

I have some folks who need to consolidate information spread across 1000 of spreadsheets into one master sheet. I could write a vba solution for some of the workbooks but they are all in different formats and have different information. Therefore, they are copying and pasting the information...

I need help for a formula to verify that only certain characters are being used in an adjacent cell. Example Cell A1 value: [AA_Abcd]12345678;QS_Foujsf Cell B1 formula: will check to ensure that only upper and lower case characters, square brackets and semicolon are used in cell A1 I am pretty...

I have in column D strings like A1B1C1D1E1 or A5B1C3D1E4 etc There can be blanks too. There length will always be even if not blank. Which means we can have from 2 characters up to 10 characters. So from the above given example if cell D2 is having A5B1C3D1E4, then I am splitting it and...

Hello. I'm struggling with a formula using IF, LEN and VLOOKUP. I need to manipulate what VLOOKUP returns. If it returns a 10 character string I need to only pull through the first 5 characters, otherwise return the entire string. =IF(LEN(VLOOKUP(A2,'[Powys...

I have a txt file that is exactly 500 characters wide and can have several thousand ‘rows’ of data that are also exactly 500 characters wide. Frequently I am required to scroll through such files and find issues with the data. That is very time consuming and modifying a file like this is...

how can i break the below array formula to two when loading macro to avoid the limitation of 255 characters? thanks guys. Selection.FormulaArray = _...

Any way to get the code to work on sheet names with only 4 characters? Cells.Find(What:="IG").EntireRow.Delete Cells.Find(What:="OG").EntireRow.Delete With ActiveSheet.UsedRange .AutoFilter Field:=13, Operator:=xlFilterNoFill...