Book1 | |||
---|---|---|---|
A | |||
1 | asdd asd asdasdasd asfasfas asfasfasas | ||
2 | |||
3 | asddasdasdasdasdasfasfasasfasfasas | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A3 | =TRIM(SUBSTITUTE(A1," ","")) |
A | B | |
---|---|---|
1 | Air | Air |
2 | Alerting | Alerting |
3 | Alternate | Alternate |
4 | Ground | Ground |
5 | Ceiling. | Ceiling. |
6 | Certificate | Certificate |
7 | Chairman: | Chairman: |
8 | Change | Change |
9 | Clearance Limit. | Clearance Limit. |
10 | Common Carriage. | Common Carriage. |
11 | Control Area. | Control Area. |
12 | Traffic | Traffic |
13 | Large | Large |
Worksheet Formulas
<thead> </thead><tbody> </tbody> |
Book1 | ||||
---|---|---|---|---|
A | B | |||
1 | Air | Air | ||
2 | Alerting | Alerting | ||
3 | Alternate | Alternate | ||
4 | Ground | Ground | ||
5 | Ceiling. | Ceiling. | ||
6 | Certificate | Certificate | ||
7 | Chairman: | Chairman: | ||
8 | Change | Change | ||
9 | Clearance Limit. | Clearance Limit. | ||
10 | Common Carriage. | Common Carriage. | ||
11 | Control Area. | Control Area. | ||
12 | Traffic | Traffic | ||
13 | Large | Large | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B1 | =IFERROR(TRIM(MID(A1,FIND(CHAR(160),A1)+1,LEN(A1)-1)),A1) |