Again, very helpful.

This is along the same lines so the formula is probably going to be
structured the same way. If you have time that would be great.

I need to get rid of the symbols in one column. I want only text. I have
tried the edit replace route but that leave me with un unnecessary space
where the period used to be.

i.e.

column A column B
..adams adams
johnson johnson
smith smith
..ward ward
wilson wilson

is this possible with an IF statement?

"Gord Dibben" wrote:

Don't forget that you can just double-click on the fill handle of B1 to copy
down to end of data in column A.


Gord

On Thu, 28 Jun 2007 11:14:02 -0700, Excel Function Application
m wrote:

Thank you very much Gord. I have several lists with different text entries
but thousands of rows...this is really going to help!

"Gord Dibben" wrote:

=IF(A1<"","(" & A1 &")","") entered in B1 and copied down.


Gord Dibben MS Excel MVP


On Thu, 28 Jun 2007 09:46:03 -0700, Excel Function Application
m wrote:

In column A there are either values of "JR.", "CPA", "MD", or nothing. Can I
create an IF statement that says if there is a text value in the cell put
parentheses around that value and if there is nothing in the cell do nothing?

Any help would be appreciated