| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
replace question
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
replace question
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
replace question
=SUBSTITUTE(B1,REPT("*",LEN(B1)-LEN(SUBSTITUTE(B1,"*",""))),A1)
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Mike" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
replace question
You rock Toppers!! Thanks!!!
"Toppers" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
replace question
Mine's cleverer, but yours is better <g
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Toppers" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Advanced Find and Replace Question | Excel Worksheet Functions | |||
| replace value in excel? | Excel Worksheet Functions | |||
| find replace format | Excel Discussion (Misc queries) | |||
| Search and Replace Question | New Users to Excel | |||
| Simple Search and Replace Question | Excel Discussion (Misc queries) | |||
Linear Mode
