IT specialist@itspecuz P.5629

Notice: file_put_contents(): Write of 17052 bytes failed with errno=28 No space left on device in /var/www/tgoop/post.php on line 50
IT specialist@itspecuz P.5629

ITSPECUZ Telegram 5629

#excel

Matn va sanani qanday qilib biriktirib yozish mumkin? 🔤🗓🤔

Agar siz shunchaki matn va funksiyani, masalan, =СЕГОДНЯ'ni biriktirib yozishga urinsangiz — sizda formatlardagi farq bois kerakli natija yuzaga kelmaydi.

Buning amalga oshirish yo‘li esa quyidagicha:

— 1-qadam
Yangi yacheykada kerakli matnni kiriting. Masalan: (Привет! Сегодня )

— 2-qadam
Joriy sanani hosil qilish maqsadida =СЕГОДНЯ() funksiyasini, keyingi (pastki) yacheykaga esa =ТЕКСТ(А1; ДД.ММ.ГГГГ) funksiyasini qo‘llang. A1 o‘rniga =СЕГОДНЯ funksiyasi qo‘llanilgan yacheykani ko‘rsating.

— 3-qadam
=СЦЕПИТЬ funksiyasi yordamida matn va siz oldingi qadamda matnli formatga o‘tkazgan sana keltirilgan yacheykalarni biriktiring.

ℹ️ Qo‘shimcha sifatida o‘qish va foydalanish tavsiya etiladi:
• Ishchi kitoblarida qo‘llash mumkin bo‘lgan tezkor tryuklar

👨🏻‍💻@itspecuz | Mundarija

www.tgoop.com/itspecuz/5629

6.51K viewsedited May 23, 2021 at 07:10

tgoop.com/itspecuz/5629

Create: 2021-05-23
Last Update: 2025-08-13 17:35:13

#excel

Matn va sanani qanday qilib biriktirib yozish mumkin? 🔤🗓🤔

Agar siz shunchaki matn va funksiyani, masalan, =СЕГОДНЯ'ni biriktirib yozishga urinsangiz — sizda formatlardagi farq bois kerakli natija yuzaga kelmaydi.

Buning amalga oshirish yo‘li esa quyidagicha:

— 1-qadam
Yangi yacheykada kerakli matnni kiriting. Masalan: (Привет! Сегодня )

— 2-qadam
Joriy sanani hosil qilish maqsadida =СЕГОДНЯ() funksiyasini, keyingi (pastki) yacheykaga esa =ТЕКСТ(А1; ДД.ММ.ГГГГ) funksiyasini qo‘llang. A1 o‘rniga =СЕГОДНЯ funksiyasi qo‘llanilgan yacheykani ko‘rsating.

— 3-qadam
=СЦЕПИТЬ funksiyasi yordamida matn va siz oldingi qadamda matnli formatga o‘tkazgan sana keltirilgan yacheykalarni biriktiring.

ℹ️ Qo‘shimcha sifatida o‘qish va foydalanish tavsiya etiladi:
• Ishchi kitoblarida qo‘llash mumkin bo‘lgan tezkor tryuklar

👨🏻‍💻@itspecuz | Mundarija

BY IT specialist

Share with your friend now:
tgoop.com/itspecuz/5629

Open in Telegram

Telegram News

Date: 2025-08-13|

best-secure-messaging-apps-shutterstock-1892950018.jpg More>> Telegram iOS app: In the “Chats” tab, click the new message icon in the right upper corner. Select “New Channel.” Select: Settings – Manage Channel – Administrators – Add administrator. From your list of subscribers, select the correct user. A new window will appear on the screen. Check the rights you’re willing to give to your administrator. Done! Now you’re the proud owner of a Telegram channel. The next step is to set up and customize your channel.
from us

Telegram IT specialist
FROM American