How to find cells that contain words that begin with a (specific) letter ("A" e.g.)?

If I want to see all the cells which contain a word that begins with “A” for example, how do I do it?

Hello

use Edit -> Find & Replace

Find: ^A
Options: Regular expressions

and click button Find all. You’ll get a result list of all cells containing a value starting with “A”

Update 1 According to the semantic of the question and with repect to the comment of @mikekaganski use:
Find: \bA

Update 2 If you want to find words beginning with an aribitrary letter and with respect to comment of @Lupp use:
Find: \b[:letter:]

In ‘Search Results’ box, it’s better than MS Excel.

Given the wording of the question (“I want to see all the cells which contain a word that begins with “A” for example”), the regex would be rather \bA. See ICU regex documentation.

Sorry - my bias.

I think ^A will only find cells where the entire content begins with A. To search for words beginning with A anywhere in the cell, try \bA where \b represents the beginning of a word boundary.

Already mentioned!

@robleyd yes - this was what I meant by my bias to interpret as entire content begins with A (I’m too much used to only search for lines beginning with certain characters on *NIX command lines).

What about using \b[:letter:] (any letter alowed) or \bA (only letter “A” accepted) as the ‘Find’ RegEx?
@anon73440385: If you also think my suggestion is valid, you may edit your answer with a respecive completion.

@Lupp: aside from the discussion already happened in the comments, and the edit already done to the answer - the \b[:letter:] seem to serve no valid purpose: “find all words starting with a word” looks like a tautology…

@Lupp Since there are very rare case where people posting questions with a clear motivation what they want to achieve, I try (more or less successfully;-)) to stick with the question but of course your suggestion is valid. Will update…

You (the OriginalPoster) may find that the meaning of the term “word” depends on what characters or text positions are supposed to delimit a word. See
Regex Tutorial - \b Word Boundaries and
Regexp Tutorial - Shorthand Character Classes for more detail.

Quoting @mikekaganski: <>…“find all words starting with a word” looks like a tautology…</>
I would assume that’s not what the suggested Regex does. Most or all common RegEx engines imply a technically extended meaning of the term “word” which includes (at least) to consist of latin letters, decimal digits, and the underscore. Since the subject of the question did not mention the specific character (I edited it later), but only the text mentioned it, I wanted to give a solution addressing the unedited subject, too, and I put the completements to the original subjects into parentheses.
This was intended to help visitors not interested in the specific letter to also find what they looked for.

Thanks @Lupp.