replace question Mike 28.09.2006 16:19:02 Hey guys! I have 2 columns A and B. What I need to do is take what is in column A and replace a string of astricks in Column B. For example: Column A Column B Result ABC need****help needABChelp DEF more****help moreDEFhelp Any idea how to do this?? Thanks guys! Mike

RE: replace question Toppers 28.09.2006 16:33:02 Try: =SUBSTITUTE(SUBSTITUTE(B1,"*",A1,1),"*","") This allows for a variable number of asterisks in Column B entries. HTH "Mike" wrote: [Quoted Text] > Hey guys! > > I have 2 columns A and B. What I need to do is take what is in column A and > replace a string of astricks in Column B. For example: > > Column A Column B Result > ABC need****help needABChelp > DEF more****help moreDEFhelp > > Any idea how to do this?? > > Thanks guys! > > Mike >

Re: replace question "Bob Phillips" <bob.NGs[ at ]somewhere.com> 28.09.2006 16:35:23 =SUBSTITUTE(B1,REPT("*",LEN(B1)-LEN(SUBSTITUTE(B1,"*",""))),A1) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Mike" <Mike[ at ]discussions.microsoft.com> wrote in message news:10D9D8BC-DAAB-466A-A6D4-8A78F5DDC351[ at ]microsoft.com... [Quoted Text] > Hey guys! > > I have 2 columns A and B. What I need to do is take what is in column A and > replace a string of astricks in Column B. For example: > > Column A Column B Result > ABC need****help needABChelp > DEF more****help moreDEFhelp > > Any idea how to do this?? > > Thanks guys! > > Mike >

RE: replace question Mike 28.09.2006 16:40:03 You rock Toppers!! Thanks!!! "Toppers" wrote: [Quoted Text] > Try: > > =SUBSTITUTE(SUBSTITUTE(B1,"*",A1,1),"*","") > > This allows for a variable number of asterisks in Column B entries. > > HTH > > "Mike" wrote: > > > Hey guys! > > > > I have 2 columns A and B. What I need to do is take what is in column A and > > replace a string of astricks in Column B. For example: > > > > Column A Column B Result > > ABC need****help needABChelp > > DEF more****help moreDEFhelp > > > > Any idea how to do this?? > > > > Thanks guys! > > > > Mike > >

Re: replace question "Bob Phillips" <bob.NGs[ at ]somewhere.com> 28.09.2006 18:24:59 Mine's cleverer, but yours is better <g> -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Toppers" <Toppers[ at ]discussions.microsoft.com> wrote in message news:9ADDB658-D2FC-490A-95A0-D5381D9AFD6A[ at ]microsoft.com... [Quoted Text] > Try: > > =SUBSTITUTE(SUBSTITUTE(B1,"*",A1,1),"*","") > > This allows for a variable number of asterisks in Column B entries. > > HTH > > "Mike" wrote: > > > Hey guys! > > > > I have 2 columns A and B. What I need to do is take what is in column A and > > replace a string of astricks in Column B. For example: > > > > Column A Column B Result > > ABC need****help needABChelp > > DEF more****help moreDEFhelp > > > > Any idea how to do this?? > > > > Thanks guys! > > > > Mike > >