Uncategories

Excel – Ambil Sebahagian Content Bermula dari Sebelah Kiri

Cara untuk ambil sebahagian content dalam sesuatu column excel yang bermula dari sebelah kiri.

Formula:
=LEFT(text; [num_chars])

Contoh:
Excel - LEFT

Excel - LEFT2

F383 = column yang terlibat
11 = ambil 11 aksara dari kiri

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s