Hi Myke, find the enclosed file On 20/01/2010, [email protected] <[email protected]> wrote: > Hi Myke, > > This can done by the following formula. > > =IF(C1="Inadequate",A1&" "&B1&" "&C1&CHAR(10),"") > > Hope this is will help you. > > Cheers, > Valli > > On Jan 20, 2:30 am, Myke <[email protected]> wrote: >> Hello All, >> >> While this may sound silly, I'm trying to concatenate values in 3 >> columns into a single cell to essentially create a list using a >> formula. >> >> A B C >> >> 1 Area1 Value1 Inadequate >> >> 2 Area2 Value2 Adequate >> >> 3 Area3 Value3 Inadequate >> >> The manual way for me to do this is: >> >> Concatenate(A1, " ",B1," ",C1,Char(10)) >> >> As you can see I want space between each value and a new line at the >> end. I want all rows where column C has "Inadequate" and for this >> concatenation to happen in one cell. The reason for this is so that I >> can refer to that cell using a text box in another sheet. >> >> I'm probably taking the wrong approach to accomplish this. Any help or >> suggestions are greatly appreciated! >> >> Thank you, >> Myke >
-- Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~
-- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to [email protected] If you find any spam message in the group, please send an email to: Ayush Jain @ [email protected] <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Solution By Ankur2.xls
Description: MS-Excel spreadsheet
