MID

ํ…์ŠคํŠธ์˜ ํ…์ŠคํŠธ ๋ฌธ์ž์—ด์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค. ์ด ๋งค๊ฐœ ๋ณ€์ˆ˜๋Š” ๋ฌธ์ž ์ˆ˜์™€ ์‹œ์ž‘ ์œ„์น˜๋ฅผ ์ง€์ •ํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

MID("Text"; Start; Number)

Text๋Š” ์ถ”์ถœํ•  ๋ฌธ์ž๋“ค์„ ํฌํ•จํ•˜๊ณ  ์žˆ๋Š” ํ…์ŠคํŠธ์ž…๋‹ˆ๋‹ค.

Start๋Š” ์ถ”์ถœํ•  ํ…์ŠคํŠธ์˜ ์ฒซ ๋ฌธ์ž ์œ„์น˜์ž…๋‹ˆ๋‹ค.

Number๋Š” ํ…์ŠคํŠธ ์ผ๋ถ€์˜ ๋ฌธ์ž์ˆ˜๋ฅผ ์˜๋ฏธํ•ฉ๋‹ˆ๋‹ค.

์˜ˆ์ œ

=MID("office";2;2)๋Š” ff๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

Please support us!