IF statements

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Thank you very much Gord. I have several lists with different text entries
but thousands of rows...this is really going to help!
 
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
 
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?
 
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
 
Shutttt uuup! Thanks, Gord

Linda

Gord Dibben said:
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
Click to expand...
 
Back
Top