U A1 imam tekst " excel" ,sa razmakom ispred excel-a... kako ukloniti taj razmak,kopirati u B1 i da bude "excel" ?
Kopiranje bez prvog karaktera u celiji
Zaključano
Zakačeno
Koristi funkciju TRIM
Ako se radi samo o jednoj riječi možeš i
a možeš i
Code:
=TRIM(A1)
=TRIM(A1)
Ako se radi samo o jednoj riječi možeš i
Code:
=RIGHT(A1;5)
=RIGHT(A1;5)
a možeš i
Code:
=MID(A1;2;5)
=MID(A1;2;5)
TRIM resava stvar,hvala :) .... Ostalo ne pomaze,jer mi treba za razlicite duzine reci
Kad već smo kod problema sa 'čišćenjem' nevidljivih karaktera, da pomenemo onda još jednu f-ju: CLEAN()
Preporučujem tekst sa portala MyOnlineTrainingHub: Excel CLEAN Formula
Preporučujem tekst sa portala MyOnlineTrainingHub: Excel CLEAN Formula
Potpis
Have you found helpful examples, solutions or ideas-in-work, please consider the
following:
• Citation of *actual page* you are going to using is welcome.
• Have you saw "Value Added" examples you are going to incorporate to your
profitable blog, daily job or any money making venture: How about online donation?
↗Ana & Vlade Divac Foundation
Hvala!
following:
• Citation of *actual page* you are going to using is welcome.
• Have you saw "Value Added" examples you are going to incorporate to your
profitable blog, daily job or any money making venture: How about online donation?
↗Ana & Vlade Divac Foundation
Hvala!