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


--
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

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" wrote
in message ...

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