please find attachement and help me
M m9vukyem Member May 29, 2021 #1 please find attachement and help me Attachments REPLACE TEXT.xlsx 9.5 KB · Views: 17
B bosco_yip Excel Ninja May 29, 2021 #2 B5, enter formula : =SUBSTITUTE(B2,MID(B2,SEARCH("#",B2)+4,SEARCH("@",SUBSTITUTE(B2,"#","@",3))-SEARCH("#",B2)-4),C2)
B5, enter formula : =SUBSTITUTE(B2,MID(B2,SEARCH("#",B2)+4,SEARCH("@",SUBSTITUTE(B2,"#","@",3))-SEARCH("#",B2)-4),C2)
M m9vukyem Member May 29, 2021 #3 bosco_yip said: B5, enter formula : =SUBSTITUTE(B2,MID(B2,SEARCH("#",B2)+4,SEARCH("@",SUBSTITUTE(B2,"#","@",3))-SEARCH("#",B2)-4),C2 Thankyou sir Click to expand...
bosco_yip said: B5, enter formula : =SUBSTITUTE(B2,MID(B2,SEARCH("#",B2)+4,SEARCH("@",SUBSTITUTE(B2,"#","@",3))-SEARCH("#",B2)-4),C2 Thankyou sir Click to expand...
M m9vukyem Member May 30, 2021 #4 how to extract words in a separte columns by using formulas (not text to columns function )from the above sentence
how to extract words in a separte columns by using formulas (not text to columns function )from the above sentence
B bosco_yip Excel Ninja May 30, 2021 #5 In C2 : =TRIM(MID(SUBSTITUTE(B2,"#~#",REPT(" ",199)),199,199))
B bosco_yip Excel Ninja May 30, 2021 #7 m9vukyem said: ok sir, But i want extract all words (each word in each cell) Click to expand... Then Change it to >> =TRIM(MID(SUBSTITUTE("#~#"&$B2,"#~#",REPT(" ",199)),COLUMN(A$1)*199,199)) Drag right until blank.
m9vukyem said: ok sir, But i want extract all words (each word in each cell) Click to expand... Then Change it to >> =TRIM(MID(SUBSTITUTE("#~#"&$B2,"#~#",REPT(" ",199)),COLUMN(A$1)*199,199)) Drag right until blank.