NEW FUNCTIONS FOR SUBSTITUTE

asked 2015-12-12 17:49:10 +0100

Nemzag gravatar image

updated 2016-01-13 12:49:43 +0100

Hi have some trouble with the func‑ti‑ôn sub‑stitute I get érr‑ôr...

Buth still I have to ask you some‑thing :

Can you please in‑stead than vrit‑ing all of this (con‑vert Latin character in others scripts (Greek, Cyrillic) : A = ܐ, B = ܒ, etc...)


=(MAJUSCULE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE($G3495;A.$B$2;A.$B$3);A.$D$2;A.$D$3);A.$E$2;A.$E$3);A.$G$2;A.$G$3);A.$H$2;A.$H$3);A.$I$2;A.$I$3);A.$J$2;A.$J$3);A.$K$2;A.$K$3);A.$L$2;A.$L$3);A.$M$2;A.$M$3);A.$N$2;A.$N$3);A.$O$2;A.$O$3);A.$P$2;A.$P$3);A.$Q$2;A.$Q$3);A.$R$2;A.$R$3);A.$S$2;A.$S$3);A.$T$2;A.$T$3);A.$U$2;A.$U$3);A.$V$2;A.$V$3);A.$W$2;A.$W$3);A.$X$2;A.$X$3);A.$Y$2;A.$Y$3);A.$Z$2;A.$Z$3);A.$AA$2;A.$AA$3);A.$AB$2;A.$AB$3);A.$AC$2;A.$AC$3);A.$AD$2;A.$AD$3);A.$AE$2;A.$AE$3);A.$AF$2;A.$AF$3);A.$AG$2;A.$AG$3);A.$AH$2;A.$AH$3);A.$AI$2;A.$AI$3);A.$AJ$2;A.$AJ$3);A.$AK$2;A.$AK$3);A.$AL$2;A.$AL$3);A.$AM$2;A.$AM$3);A.$AN$2;A.$AN$3);A.$AO$2;A.$AO$3)))


To use this one :
=(MAJUSCULE(SUBSTITUE($G3495;A.$B$2:A.AO$2;A.$B$3:A.$AO$3)))
=(MAJUSCULE(SUBSTITUE($G3495;A.$(B:AO)$2;A.$(B:AO)$3)))

or

=(MAJUSCULE(SUBSTITUE($G3495;A.$*$2;A.$*$3)))  {* = ALL}


And in others case of superposed table :
=(MAJUSCULE(SUBSTITUE($G3495;A.$B$2:A.B$40;A.$C$3:A.$C$40))) 

or

=(MAJUSCULE(SUBSTITUE($G3495;A.$B$(2:40);A.$C$(3:40))))

or

=(MAJUSCULE(SUBSTITUE($G3495;A.$B$*;A.$C$*))) {* = ALL}

IT WOULD BE LOT BEDDËR !!!
AND WITH‑OUT LIMITA‑TI‑ÔN OF SUB‑STITUTE (POLY TʰAN 200)
BE‑CAUSE NOW I GET ERR:514 !!!

KANTH YOU, ƷOOD DAY.
edit retag flag offensive close merge delete