Split numbers and currency symbols in cells

1.

bus line: No.3 → No.15, the whole journey is about 10.3km

1. Walk about 90m from Tonghua highway passenger station (old station) to passenger station

2. Take No.3 bus, pass 3 stations, and then reach Petrochemical station (or take No.39 bus)

3. Walk about 150m to Yamaha motorcycle monopoly station

4. Take No.15 bus, pass 11 stations, and reach gas station (G201)

5 Walk about 320 meters to the driver examination center of traffic police detachment of Tonghua Public Security Bureau

2. Go out to install, repair and debug equipment for customers.

3. Don't worry about mining machines. They are full loaded for 7 * 24 hours. If there is a problem, they won't be guaranteed after sales. Belongs to the super specification load accessories, now does not allow to fry the currency, the miner took to sell 2 hands.

4. Select data -- data -- column -- fixed width -- next step -- set field width (separate currency symbol from number -- three digits in general?) Just click on the scale) - next step - done.

5. Suppose the amount is in A68, the rightmost space is N68, and the rightmost space is input = if ($A68, left (& right&# 165;& quot;&$ a68*100,COLUMNS(N:$N))),"& quot;) Right pull

6. First, the format of the cell is set to text format, and then when you it, select paste, value
then enter = left (b1,1) in C1, mid (b1,2,1) in D1, mid (b1,3,1) in E1, mid (b1,4,1) in F1 and right (b1,1) in G1.

7. < UL >

method 1:

first, right-click the merged cell and find set cell format in the menu

8. What cell is the amount in
suppose K2
= left (right (& quot; ￥"&$ K2 / 1%, 12-column (A1)))
right pull

9. You try to use Notepad
1) cells in Excel, and then paste them into Notepad
2) cut the contents in Notepad
3) return to excel, locate the cell at the beginning of the input area, select "data" -- "text column" in the menu bar, and then jump out of a window, and you will do it yourself
of course, in the last step, You can also paste directly in Excel, and then a small symbol will appear in the lower right corner. Click it, and you will see a matching source text content... Click it, and the same sub text window will appear.