RAJESH1960
Banned for repeated rules violations
- Joined
- Mar 26, 2020
- Messages
- 2,313
- Office Version
- 2019
- Platform
- Windows
Hello, I have too many rows in a sheet where some cells have an extra space. I want to remove it with the help of a formula in the same column or an adjacent column by which I can remove the extra space. I have already tried trim and substitute function but it doesn't help.
| Query to remove space.xlsm | |||
|---|---|---|---|
| A | |||
| 1 | X4361 | ||
| 2 | X5281 | ||
| 3 | X6805 | ||
| 4 | X9574 | ||
| 5 | X9596 | ||
| 6 | X11134 | ||
| 7 | X1634 | ||
| 8 | X2682 | ||
| 9 | X9127 | ||
| 10 | X9233 | ||
| 11 | X9338 | ||
| 12 | X9441 | ||
| 13 | X9514 | ||
| 14 | X9365 | ||
| 15 | X9387 | ||
| 16 | X9602 | ||
| 17 | X9671 | ||
| 18 | X9708 | ||
| 19 | X9115 | ||
| 20 | X9169 | ||
| 21 | X9564 | ||
| 22 | X9926 | ||
| 23 | X10488 | ||
| 24 | X8975 | ||
| 25 | X9237 | ||
| 26 | X9577 | ||
| 27 | X9609 | ||
Query | |||
