manoj18071965
Board Regular
- Joined
- Sep 16, 2011
- Messages
- 65
I have a long list in column A in excel. I am seeking for formula to clear below formatting errors:
Below is the example of output required:
<tbody>
</tbody>
- Remove Extra space or spaces appearing before text starts in a cell
- Remove Extra space or spaces appearing after text starts in a cell
- Remove comma if appearing at the end of text in a cell
Below is the example of output required:
Actual | Output Required |
Assoc Prof. | Assoc Prof. |
Assoc Prof. | Assoc Prof. |
Assoc Prof., | Assoc Prof. |
Assoc Prof., | Assoc Prof. |
Assoc Prof., | Assoc Prof. |
Assoc Prof., | Assoc Prof. |
Assoc Prof., | Assoc Prof. |
Assoc Prof., | Assoc Prof. |
Assoc, Dean & Prof. | Assoc, Dean & Prof. |
Assoc, Dean & Prof. | Assoc, Dean & Prof. |
Assoc, Dean, Prof., and Dir., | Assoc, Dean, Prof., and Dir. |
Assoc, Dir., Jt. Degree Applied Legal Theory & Analysis Prog., | Assoc, Dir., Jt. Degree Applied Legal Theory & Analysis Prog. |
Assoc, Prof North- western | Assoc, Prof North- western |
Assoc, Prof. & Dir., | Assoc, Prof. & Dir. |
Assoc, Prof. & Dir., | Assoc, Prof. & Dir. |
Assoc, Prof. | Assoc, Prof. |
Assoc, Prof. | Assoc, Prof. |
Assoc, Prof. | Assoc, Prof. |
Assoc, Prof. | Assoc, Prof. |
<tbody>
</tbody>