Excel to extract space before and after data tips

How does Excel extract data on both sides of a space? Many times we need to use Excel to extract the data from the left or right of the space, and now we share the skill of Excel to extract the data before and after the space.

One, Excel breakdown. Excel is a column in which the data is divided into two columns according to a certain rule. Take office2007, for example, the data--a breakdown--the separator symbol--the next step--hook up the space--next--Select the target area--complete.

Second, to extract the data on the left of the space, you can use the formula =mid (A1,1,find ("", a1,1)-1), extract the data on the right of the space, you can use the formula =right (A1,len (A1)-find ("", A1))

Classification:

• Excel Tutorials