IF statements

[Excel Function Application]

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

 

[Gord Dibben]

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


Gord Dibben MS Excel MVP

 

[Elkar]

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]

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]

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

 

[Excel Function Application]

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]

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

Copy A to column B then do your edit>replace on B only.

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

Otherwise just do the edit>replace on column A and dispense with B

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


Gord

 

[Linda \(RQ\)]

Shutttt uuup! Thanks, Gord

Linda

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

 

[Gord Dibben]

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

Gord

Shutttt uuup! Thanks, Gord

Linda

 

[Teethless mama]

one way...

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