mindbender
New Member
- Joined
- Oct 30, 2015
- Messages
- 13
Is this possible to remove anything not 8 characters long from a cell in a column.
for example Column H has 4 rows (there is data in columns A-G as well but I am only looking at column H to make this change):
<colgroup><col></colgroup><tbody>
</tbody>
for example Column H has 4 rows (there is data in columns A-G as well but I am only looking at column H to make this change):
1. NBS CM XTEND 14260 FXC041465 FXC041466, FXC041774 | ||
2. NBS "INSTALL" 9HB915543 ...+51 | ||
3. RET SS PBB009144 | ||
4. RET CONV BG0960335 Is there something I can do so that once updated the columns look like this: 1. FXC041465 FXC041466 FXC041774 2. 9HB915543 3. PBB009144 4. BG0960335
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col></colgroup><tbody>
</tbody>