Selecting cells that contain text in a specific format

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

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.


---
Regards,
Norman



"nicad_adam" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
>
> --
> nicad_adam
> ------------------------------------------------------------------------
> nicad_adam's Profile:
> http://www.excelforum.com/member.php...o&userid=24178
> View this thread: http://www.excelforum.com/showthread...hreadid=379976
>