Results 1 to 9 of 9
Thread: Excel
Hybrid View
-
10th July 2013 09:19 #1Registered User
Join Date: Nov:2005
Location: Sofia
Posts: 118
Excel
, , PROPER, !
-
10th July 2013 09:44 #2EP43-DS3|E5200@3.33|ASUS EN9800GT HB /HTDI/ 512MB|2X2GB 800MHZ CL5 A-DATA|WD2500JB|NEC 4750A|BELINEA 1980S2
-
10th July 2013 17:58 #3Registered User
Join Date: Nov:2005
Location: Sofia
Posts: 118
. "=SUBSTITUTE(LOWER(C2),CHAR(CODE(C2)),UP PER(CHAR(CODE(C2))),1)", "The formula you typed contains an error". excel 2007 . "Use system separators", .
-
10th July 2013 18:01 #4
UP PER ,
: XaMaB; . 0.42
In God we Trust (all others must submit a X.509 certificate). , ()
-
10th July 2013 21:50 #5Registered User
Join Date: Nov:2005
Location: Sofia
Posts: 118
.
-
10th July 2013 23:26 #6
2007

Code:=SUBSTITUTE(LOWER(C2);CHAR(CODE(C2));UPPER(CHAR(CODE(C2)));1)
: XaMaB; . 0.42
In God we Trust (all others must submit a X.509 certificate). , ()




Reply With Quote
7th May 2023, 16:02 in PC