count characters

  1. angeloudaki

    countif cell contains less than 6 characters, or contains digits

    How do I count a cell if it contains less than 5 characters, or contains digits (even if mixed with letters)? After data transfer, I have a list - some are email addresses, some usernames, some random text. I want to filter these to username which are less than 6 characters (for example) so us...
  2. C

    count how many times I've got the same character in text from several cells

    Hi smart people! this should be not too difficult for you... ;-) I need to count how many times I've got, for instance, "a" in several cells where I typed some text... I would need a formula where I can indicate the letter I want and the range of cells where to look at, and having as result...
  3. L

    Determine if part of a multi-line cell has been deleted using VBA

    I'm using Excel 2007. Using VBA, I need to determine if part of a multi-line cell has been deleted. Example Contents of cell A1 before user clicks on the cell -comment 1 -status 2 -status 3 User deletes second line -comment 1 -status 3 I need to determine if a 'line' has been...
  4. S

    Count spaces before specific character in cell

    Hi :) Is it possible to create a formula that will count the number of spaces in a cell that occur before a specific character? So if the contents of A1 was: "The quick fox (jumped/leaped) over" Then B1 would read 3, because there is are 3 spaces before the open bracket, and any spaces after...
  5. P

    Count Text / Words

    Hi All, I want to import webpages and do some basic analysis on the content of the text on the webpage. Doing this in a rough way, I have used data query to import the text from a given webpage and it has left me with several lines of text in various cells running from A1:A120. I would...
  6. R

    counting text values up to a certain amount of times that letter appears

    I am looking to count how many times an "x" appears in a row up to 5 times. If it appears more than 5 times I want to stop counting that letter. What formula should I be using?
  7. D

    Counting specific words in a sibgle cell

    Greetings all you Masters of Excel What I need to do is count the number of occurrences there are of a given word in a single cell (Excel2007) example cell contents = pig pig cow sheep pig horse how many 'pig' answer 3 be fab to have a percentage as well e.g 50% of words Whose got the magic...
  8. G

    Vlookup Exact match instead of wildcard

    i'm trying to do i Vlookup but i'm looking up for example 50212 but where i'm trying to find it, it looks like this 50212sd-23-2-09 is there anyway i can do =vlookup(a2, (left, 5) A5-C5, 3, false) Also is it possible to put a count in so it counts how many characters are in...
Learn Excel from Bill Jelen

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

This Week's Hot Topics

  • link pictures from Sharepoint to Excel macro
    Hi, I need your help to fix this issue. I have a code and this is work on my computer. But now I try to link the picture from the SharePoint to...
  • lookup match return closest to x date
    Hi all, Happy New Year, this is my first post in 2022. I have two worksheets I'm working with. worksheet one is titled KPI Data - MY22 ONLY It...
  • Average hours per week
    I'm trying to find a simpler/quicker way to obtain the average number of hours per week for employees. My spreadsheet contains columns for Date...
  • Google Sheets IMAGE Function
    Is there any way to replicate the IMAGE function from Google Sheets in Excel? Maybe a VBA code? From what I can tell, the function in Google...
  • Identify equipment used -No of consecutive days
    Hello, I appreciate your time and effort. I would like to have formula for column O and P. Column A : lots of Asset Column C: date If one Asset...
  • Filling in data from source
    Hi All, I'm not quite sure what to call the following type of data manipulation so I don't quite know how to phrase my question. Below is an...

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
Top