 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / June 2007IF statements
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 >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! > =IF(A1<>"","(" & A1 &")","") entered in B1 and copied down. > [quoted text clipped - 5 lines] > > > >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 >Thank you very much Gord. I have several lists with different text entries >but thousands of rows...this is really going to help! [quoted text clipped - 8 lines] >> > >> >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? > 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. [quoted text clipped - 13 lines] > >> > > >> >Any help would be appreciated 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 >Again, very helpful. > [quoted text clipped - 33 lines] >> >> > >> >> >Any help would be appreciated Shutttt uuup! Thanks, Gord Linda > Don't forget that you can just double-click on the fill handle of B1 to > copy [quoted text clipped - 18 lines] >>> > >>> >Any help would be appreciated You're welcome...........I think<g> Gord On Thu, 28 Jun 2007 19:55:29 -0400, "Linda \(RQ\)" <Linda@TenForward.Laptop> wrote: >Shutttt uuup! Thanks, Gord > [quoted text clipped - 22 lines] >>>> > >>>> >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 > 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&")") > 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
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.