character

Greetings Excel Community, I have a set of data and i am wondering if there is code or formula that can be created to parse these values into comma delimited dates. The dates are combined together to make it look as a long string, however i am attempting to create the end result under the...

I want to SUM the numbers in a row which represent the worked hours in a month. The numbers in the cells have a leading string character like V8 or S8 or H7,2. How can I do that. See the mini sheet below for layout and desired results. Thank you very much...

Hello, Is there a way to collapse the first repeated characters of a string into a single character? My current data looks like the one in column Object2 and I want to transform it so it looks like the one in Result. In other words, if a string inside a cell starts with 3 'Cs', I want the...

Hi, I downloaded a csv from a database online and the Greek characters are appearing as question mark. Please the attachment to understand my concern. Any help will be appreciated! Thanks

I was wanting to see if there was away to add some code to my personal workbook so when I open and or save a workbook where the file path is more than 218 characters I will get a prompt telling me Ive exceeded the recommended character limit.

Hi, I have the code shown below. My intention is that cell Z21 must be UPPERCASE So typing tom jones in cell Z21 then when i leave that cell it changes to TOM JONES Private Sub Worksheet_Change(ByVal Target As Range) With ThisWorkbook.Sheets("HONDA SHEET") If Not Intersect(Target...

Very interesting. The data is imported from another source like this: 48 Limestone St.Markham, ON L6B0P6 (no space after St.) When applying Wrap Text it shows up as: 48 Limestone St. Markham, ON L6BOP6 When I use =Left(cell, 18) or =left(cell,17) I note that the result is the same - 48...

I have an excel spreadsheet containing many rows copied from VBE. Some of these contain comments - always with a ' in column 1. I would like to delete these lines, but the ' is a hidden character and the program can not find it. Any suggestions, please?

I need to create a custom cell format as follows: Example: 17a > This custom format would only require me to enter for example 6c OR 23d OR 3f OR 17a OR whatever #a OR whatever #b OR whatever #c etc. etc. etc. Do you get the picture? Before the need for an alpha character this was simple...

Hello, I need to extract the route number, which can be between 1 to 3 digits, see example below: Route 1-1 South Route 26-7 Ludlam Route 29-2 West Route A 101-1 North As you can see the Route value and (-) dash character are constant. Is there a formula in excel and/or PowerBi I can use...

Hi, The title says it all. I'm trying to extract the text between a character (character is "%") and the first space to the left of that "%" character. I figure it would need to include the left and find functions but I am having a hardtime figuring out how to put it all together. Any help...

Hello, I'm using Excel 2016 and am trying to find the ampersand character (&) in a cells that are just characters. There is no = at the beginning of the string. Something like Victory & International. I've googled for that and didn't find anything the pertains to my situation. So, how do I...

These are a few things I want to bypass. I am using textbox1 and textbox2 These are for textbox2: 1. The textbox should take only numbers and letters no other character accepted. 2. Letters should not start the entry. So A5 is not allowed 3. After a letter, no more input should be allowed...

Hi I have some tedious data entry to do into a spreadsheet. Mostly text. Every once in a while I have to use the 1/2 character in a string So I can copy and paste the character from the clipboard (very quick) but copy/paste gets used a lot anyway so then I have - to stop typing. go find the...

Hi Folks I need small macros removeing Last 5 character of the Word In Exp: AT_1833 I need AT only. Removring _1833

Hello again, You guys are so helpful! I currently have the following formula on a cell: =INDEX(DI1:DT1,MATCH(MAX(DI2:DT2),DI2:DT2,0)) It is working great. However, I would like to add additional functionality to the formula, where 19 characters of the output are removed from the left, and 31...

I am trying to put asingle text character al the way right when using "courier new" itlines up in he same place. The setup is: Name cell: Last, First Group cell: can be character two, three, or fourcharacters, and will be listed first Using FIND to get just the LEN of Last nameand comma...

Hi, I am using this working code shown below, It works like this. I complete each cell in my new row. In cell B7 i enter 17 characters,the 10th character is shown in a red font. Cell E has a date automatically entered due to this 10th character. If for any reason i decide to delete row 7 at a...

Hi, I need to create a formula that looks at the mid point of a cell =MID(CellA1,20,????) and starts at character 20 and returns the next 2 words before a space. Cell A1 contains "AAAAAAAAAAAAAAAAAA RyanSmith Recruitment AFH 0967" Cell A2 contains "AAAAAAAAAAAAAAAAAA JonBlot Recruitment AFH...

Hi, I am using the code below which works fine. Private Sub Worksheet_Change(ByVal Target As Range) Dim c As Range On Error GoTo AllowEvents If Target.Count > 1000 Then Exit Sub If Not Intersect(Target, Range("B:B")) Is Nothing Then For Each c In Target If c.Row > 5 And...