excel breakdown, separated from his final figure!

A1:90/7-8 CSDBVF 1CSBFCSBF CASF DASBFSEBF 105110
A2:70/7-8 CSDBVF 1CSBFCSBF CASF DASBFSEBF bcsabvsdb 125
A3:60/7-8 CSDBVF 1CSBFCSBF CASF DASBFSEBF bcsabvsdb cnsdvn 1541123

Now wants to visit every child behind and in front of the number of separate data,
what else can they do it? Is the space behind the last of the other data do a!

cut + copy.an increase in the back of the receipt can be placed on the go.menu-> data-> text to columns:choose “Delimited-> delimiters (choose” “or “1” -> finished steps:
1, exterior and interior work in Excel by Alt + F11, open the VBA programming interface
2, in the VBA programming interface tool bar, the second button to pull down Module election
3, the left column of the “Module 1” on double-click to open the process of writing the right of the region
4, the following code to paste into

Sub divLase ()
Dim rn As Range
Dim LastSPPos As Integer
For Each rn In Selection
LastSPPos = InStrRev (rn, “”)
If LastSPPos> 0 Then
rn.Offset (0, 1 ) = Right (rn, Len (rn) – LastSPPos)
rn = Left (rn, LastSPPos – 1)
End If
Next
End Sub

5, the closure of VBA Back to the programming interface worksheet
6, first select the format you need to organize the unit's regional
7, according to Alt + F8 to open the “macro” dialogue window
8, in the window, select “divLast “And then click the” implementation “button

now in the exterior and interior work should you want to see the results of the.

(To remind:in Exce through the menu” Tools – Macro – Security, “the macro security level is set low or to allow the macro to run, or can not run macros are not the result you want) B1 enter the formula
= RIGHT (A1, LEN (A1)-FIND (“#”, SUBSTITUTE (A1, “”,”#”, LEN (A1)-LEN (SUBSTITUTE (A1,” “,””)))))
B1 to copy the formula down

In fact, the “data – points out” more simple method:
menu:Data –
breakdown in the pop-up dialog box, step by step operation, remember to choose separator, the election “a space “

added:

C1 enter the following formula, A1 to be removed after the number of characters
= trim (substitute (A1, B1 ,””))