您的位置 首页 WPS教程

Excel中取前几位数、中间几位数、后几位数的方法

在Excel中,我们可能会遇到取一组数据前几位数,中间几位数,或者后几位数的问题,这该怎么办呢?今天就教大家在Excel中用left、mid、right函数分别取出前几位数、中间几位数和后几位数的方法。

Excel中取前几位数的方法:left函数法 (取值的数值,取值的位数)

a1中有一组数据,取前3位。点击a2单元格(大家选取自己想要将数据放入的单元格,这里假设放入a2),在a2中输入“=left(A1,3)”,如图:

>>免费升级到企业版,赠超大存储空间

按下enter键,即可出结果:

>>免费升级到企业版,赠超大存储空间

Excel中取中间几位数的方法:mid函数法 mid(取值的数值,取开始位置序号,取值位数)

a1中有一组数据,取中间3位。点击a2单元格(大家选取自己想要将数据放入的单元格,这里假设放入a2),在a2中输入“=mid(A1, 2,3)”,如图:(千万别忘了打“=”):

>>免费升级到企业版,赠超大存储空间

按下enter键,即可出结果:

>>免费升级到企业版,赠超大存储空间

Excel中取前几位数的方法:right函数法(取值的数值,取值的位数)

a1中有一组数据,取后3位。点击a2单元格(大家选取自己想要将数据放入的单元格,这里假设放入a2),在a2中输入“=right(A1,3)”,如图:

>>免费升级到企业版,赠超大存储空间

按下enter键,即可出结果:

>>免费升级到企业版,赠超大存储空间

好了,以上便是这个问题的全部方法了,综合来看还是mid函数的运用更加灵活,应用也更加广泛,希望这个方法能给大家带来帮助!

热门文章

发表评论

电子邮件地址不会被公开。

18条评论

  1. Wow, superb weblog layout! How long have you been blogging for?
    you made running a blog glance easy. The full look of your web site is excellent, let
    alone the content material!

  2. I feel that is among the such a lot significant info for me.
    And i’m happy studying your article. However want to observation on few basic issues,
    The web site style is wonderful, the articles is in point of
    fact great : D. Excellent activity, cheers

  3. Very nice post. I just stumbled upon your blog and wished to say
    that I have truly enjoyed surfing around your blog posts.
    In any case I’ll be subscribing to your rss feed and I hope you write again soon!

  4. Hey there I am so delighted I found your site, I really found you by mistake, while I was searching on Yahoo for something
    else, Nonetheless I am here now and would just like to say kudos for a remarkable post and a all round interesting
    blog (I also love the theme/design), I don’t have time to look over it all at the minute but I have bookmarked it and also included your RSS feeds, so when I have time I will be back to
    read much more, Please do keep up the excellent job.

  5. I was wondering if you ever thought of changing the layout
    of your site? Its very well written; I love what youve got
    to say. But maybe you could a little more in the way of content so people could
    connect with it better. Youve got an awful lot of text
    for only having 1 or 2 images. Maybe you could space it out
    better?