Selecting cells that contain text in a specific format

[nicad_adam]

Hi all,

I have a list of clients who are extracted from access but I need to
change the saluation from the clients initials to Sir/Madam.

For Example

Surname Firstname Salutation
-------------------------------------------

Smith G Sir/Madam
Andrews A B Sir/Madam
Green R C L Sir/Madam
Jones Mary Mary

Initially, I was just going to highlight any entries in the firstname
column that contained a space give the a value of true which would
change the saluation to Sir/Madam. However this does not take into
account the clients with only on initial.

Any help would be greatly appreciated.

Cheers,

Adam

 

[Norman Jones]

Hi Nicad_Adam,

However this does not take into
account the clients with only on initial.

In a helper column, dragging the formula:

=LEN(B1)=1

will return true for single initial entries.