Formula whites do not seek a simple trick to learn the common string function


WPSharmonyEXCEL There are a number of string functions in,LEFT/RIGHT wait a minute!, One minute counting from the left, the next from the right., It's a pain in the ass., For the highly meritorious" Formula Man" Naturally, it's not a problem., But it's a big headache for formula whizzes。 there is no" lit. one move leads the whole country (idiom); fig. a shortcut to success" What about the way? Of course I have., is the string function we are introducing today:MID

I. Explanation of the formula

= MID (string, starting from the first character, get several characters)

for example: To get the string from the:" cubeQ Brother Self-Media" in, obtain" self media" three characters, It should start with the first digit of the string5 Characters start, fetch3 Just a few characters。

Example.

Formula Application

This formula, LEFT and RIGHT will seem to be eclipsed, remember this one function is enough. Let's look at a few scenarios for application.

1.Obtaining a first and last name

Date of birth obtained in ID card

Formula Tips

To get a surname in a batch of say 10,000 names, the surname contains single and compound surnames, single and compound surnames mixed together, how quickly can the task be completed for a formula whiz?

For this problem can be nestedIF function, First determine if it is a compound or single surname, Then make sure.MID Parameters of the function, Of course it is." Formula Man" practices。 Formula geeks can do it the easy way

1. Filter out the names of single surnames and use the MID function to obtain the string of single surnames

2. Filter out the name of the compound surname, use the MID function to obtain the string of the compound surname

Two simple, if not grand, steps to get the job done quickly.

thought-provoking question

The strings in theA2 modular: " cubeQ Brother Self-Media", formulas:=mid(a2,5,3); first time out5 Characters start, fetch3 six characters, The result obtained is the string: " self media"。

Then: the formula reads =mid(a1,5,5) ; Will WPS and EXCEL report errors?


Recommended>>
1、2018 Internet Healthcare Innovation and Entrepreneurship Conference to be held in Chengdu in the near future
2、Why do hundreds of thousands of people still get cheated by Baidu ads when everyone is not optimistic about the cryptocurrency world
3、How many of the common methods of strings do you know
4、Do phone robots cause telemarketers to lose their jobs
5、python using requests re crawl douban movie top250 simple beginner crawler

    已推荐到看一看 和朋友分享想法
    最多200字,当前共 发送

    已发送

    朋友将在看一看看到

    确定
    分享你的想法...
    取消

    分享想法到看一看

    确定
    最多200字,当前共

    发送中

    网络异常,请稍后重试

    微信扫一扫
    关注该公众号