Dear All,
I have a column with the following typical data:
1234-345-abc-435
2345-432-ab-342
My objective is to have four letters in the abc. If there is 3 or 2 letters as in this example (abc & ab) It has to introduce space like below: so as maintain 4 letters
1234-345-abc -435
2345-432-ab -342
Can someone advice me how to do this.
Thanks in advance
sms
Bookmarks