Shutttt uuup! Thanks, Gord

Linda

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