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

=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

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

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

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

If you want column A retained as is..................

Copy A to column B then do your editreplace on B only.

With your sample data, if you replace the dot(.) with nothing you should not
have any spaces.

Otherwise just do the editreplace on column A and dispense with B

If the dot was just a general sample, what other symbols do you need removed?


Gord


On Thu, 28 Jun 2007 12:32:03 -0700, Excel Function Application
m wrote:

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

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

You're welcome...........I think<g

Gord

On Thu, 28 Jun 2007 19:55:29 -0400, "Linda \(RQ\)"
wrote:

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

Since you only have 3 values, I think the easiest way to do this would be
using FIND/REPLACE.

Select your range of data
From the Edit Menu, choose "Replace"
In the Find What field enter: JR.
In the Replace With field enter: (JR.)
Click "Replace All"
Repeat for CPA and MD

HTH,
Elkar


"Excel Function Application" 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

one way...

=SUBSTITUTE(A1,A1,"("&A1&")")


"Excel Function Application" 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