character

  1. M

    Remove Characters Expect

    I've attempted to search online, but with zero luck. Is there a way to remove all characters in a string except a specified string? My string is NP. I have a column that will have different variations of NP. For example CRNP or CRNP MSN and my end goal is remove all characters and just end up...
  2. Chookz

    Select range up to a certain character

    Hey all, I am looking to select a column range up until the character "-" is encountered. The array is C8 to C17. I tried the following: =OFFSET(C8, 0, 0, MATCH("-", C8:C17, 1)-1, 1) But wasn't quite working as expected. Any help would be much appreciated Cheers
  3. gheyman

    ACCESS: TABLE Calculated Field

    I have a field where the data type is Calculated Left([Emp_LastName],5) & Left([Emp_FirstName],2) FYI This creates a UserID. I want this is be the default but let the user make up a 5 character one if they choose. whats the best way to do this?
  4. K

    Extract predefined numbers of characters, and join them in one cell

    Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> 1-My data columns C:P in cells</SPAN></SPAN> 2-Predefined numbers columns R:Z</SPAN></SPAN> 3-Extract and join them in columns AB:AJ</SPAN></SPAN> Extract predefined number of characters from columns C:P (as per specified in columns R:Z) and...
  5. K

    Fill missing character from the series

    Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> Data located in columns C:J in cells C6:J36</SPAN></SPAN> In the columns L:S I have filled some numbers and in the same rows columns C:J characters are highlighted according in order of the columns (L:C, M:D, N:E, O:F, P:G, Q:H, R:I, And...
  6. jakeman

    How to handle input box error

    Hey guys - I have an inputbox in my macro that will prompt a user to enter a 3 month character for 1 of 12 months: Jan, Feb, Mar, etc. If the user doesn't type a value or most importantly, incorrectly types the month character like Jam instead of Jan, I want an error handler that will notify...
  7. I

    If the Second Character in A3 is _ then use X formula if not use Y formula

    Sample data set below shows two separate text options within the column if the data has the _ within the cell I need to run a different formula than the ones without a _. And to avoid mistake the _ should only appear in the second character position. <colgroup><col width="65"...
  8. R

    unable to remove paragraph-special characters from string values

    I've loaded a data set from our accounting database, into an array. The accounting database users appear to be accidentally pressing the enter key in the description field, saving the data afterwards. When I dump my array containing all of this information, into an excel sheet, the...
  9. K

    How do I find out how many cell have a character writen in them?

    How do I find out how many cells have a character write in them? Is there a formula for this? Thank you. Below is a picture of what I mean. https://ibb.co/c8AhnJ
  10. S

    Convert numeric value to string made of characters representing the value

    Hi all, this one is hard to describe, but basically I want to take a numeric value, then insert a character (text character or symbol, such as X) for each of the instances of that number. For example: If B2 has a value of 7, I want C2 to show a visual representation of the numeric value (7)...
  11. B

    Count Characters Minus One

    I am using Len Function to count number of characters: =LEN(A1) Now, I have instances that I would like to count as one character and not 2. For example, instances like "DZ" or "LJ", if they exist anywhere in the word it should be counted as -1 to the total of characters. I can solve this...
  12. M

    Is there a limit to the character length of a lookup_value?

    I have recently had a series of problems with Vlookup where the lookup_value has a character length >7 digits. I found a way around the problem with Index and Match, but now wonder is it a known glitch or something wrong with my computer, Excel version v2016?
  13. R

    How to find a character in a text string without creating an error?

    I need to check when characters are and are NOT within a cell. =IF(AND(FIND("<>"&"!",$G11),FIND("<>"&"^",$G11)),1,0) G11 = !Project Planning The first logic test will produce a TRUE, but instead of the second one giving a FALSE, it gives a #VALUE error. I know I can do the reverse by doing...
  14. C

    Getting special characters to save within a CSV

    When I export my XLSM sheet to a CSV I have a special character that turns from the character Φ in the XLSM to a ? in the CSV I have tried saving the sheet as CSV then going into Tools->Web Options->Encoding-> and selecting Unicode (UTF-8) but is still turns this character into a ? when I open...
  15. A

    Check letter capitalisations

    Hi all, Is it possible to conduct the following checks in the order listed? 1. Is the first character a number or letter, if it's a letter, is it capitalised? If it's not capitalised, it needs review. 2. Is any character after any space capitalised and the following character not capitalised...
  16. A

    Limitations in VBA

    Hello guys, I have an audacious project in my mind. I want to draw a 16 colour bitmap file in VBA. I want to draw the messages af an LCD display that has 5 lines of 30 characters The file has a size of about 170Kb. I wonder what are the limitations of VBA. Furthermore, is my hardware going to...
  17. P

    Formula Based on Characters

    Hi. got a question (hopefully quick) regarding formula based on characters within cells. If i want to display a certain value if the first two characters in cell a2 are greater than the first two characters in a1 how would i do this? I've tried (cells are different i am aware but same...
  18. B

    Determine if first character in string is greater than zero

    I have a dataset with numerous combinations of alpha and numeric values in a given column. I need to do TWO things. 1) Determine if the 1st character is numeric - if so, the initial condition is met. 2) If numeric, is the character between 1 and 9 (greater than 0) - if so, the final condition...
  19. B

    Compare character to character and put results in different column

    Hello, I have a need to compare 2 columns and put the result in the third column. The critical part here is to compare letter to letter. so unable to find a logic to do this. Request your help The data is as below: <colgroup><col span="2"><col></colgroup><tbody> Column1 Column2 Result...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top