I have these values in a column:
1233456 ABC-DEF
12349845863446 JKL-MNO
1234667 UVWWW-XYZ
3445767545
What I want the column to look like:
ABC123456
JKL12349845863446
UVWWW1234667
3445767545
Any help will be appreciated, thank you!
Please see my solution using the text to column tool.
regards,
Kamen
User | Count |
---|---|
108 | |
89 | |
78 | |
54 | |
40 |