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...
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...
I'm using Excel 2007. Using VBA, I need to determine if part of a multi-line cell has been deleted.
Contents of cell A1 before user clicks on the cell
User deletes second line
I need to determine if a 'line' has been...
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...
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.
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)
cell contents = pig pig cow sheep pig horse
how many 'pig'
be fab to have a percentage as well e.g 50% of words
Whose got the magic...
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
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...