String capturing, splicing, and pivot tables in Excel

Source: Internet
Author: User
Tags truncated

Assume that the table is as follows:

How to obtain the data of column E (in the format of Schema name. Table name, such as pdm_data.t05_gms_nav_spv_pch_rdm_trx_evt )? How does one obtain column F Data from column E (extract the table name from Class E )?

1. String concatenation

In column E, enter: = C3 & "." & D3

2. String Truncation

First, we will introduce several functions:

LeftFunction,RightFunctions andMidFunction

Left function Syntax: Left (text, num_chars), part of the string from the left

Right function Syntax: Right (text, num_chars), part of the string from the right

Text indicates the string to be truncated, and num_chars indicates the number of characters to be truncated.

Mid function Syntax: Mid (text, start_num, num_chars), part of the string starting from a certain position in the middle

Text indicates the string to be truncated, start_num indicates the number of characters to be truncated, and num_chars indicates the number of characters to be truncated.

Here we select the mid function for string truncation:

3. Pivot table

The so-called pivot table is actually a statistical table. Let's talk about it later ~

String capturing, splicing, and pivot tables in Excel

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.