Go to Qiita Advent Calendar 2024 Top
LoginSignup
0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 1 year has passed since last update.

@DarkEye

スプレッドシートでIPアドレスをオクテット毎に分割する

Last updated at Posted at 2022-08-27

IPアドレスをオクテット毎に分割したいとき。
image.png

SPLIT関数を使う

SPLIT関数を使えば、指定した文字列を特定の文字で分割できる。
image.png

①SPLIT(IPアドレスを入力したセル,".")と入力する。
image.png

②[.]で区切られた文字が自動で右のセルにも反映される。
image.png

③あとは適当にセルをくっつけてNWアドレスでも作成しておく。
image.png

④適当に下まで引っ張れば完成。
image.png

最後に

正規表現とかGASでやろうと思っていた自分がいた

0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
Sign upLogin
0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?