furnitureheaven
Registered User.
- Local time
- Today, 12:54
- Joined
- Aug 5, 2008
- Messages
- 36
Hi I have some data in excel sheet in mix (Letter & Number) format e.g
A
SCCL 1574
LC08199
KS03559
SC70341
SCCL 2033
LC08758
AB04291
KS04018
I want this field to split into 2 (Letter should be in separate and number separate). e.g
A B
SCCL 1574
LC 08199
KS 03559
SC 70341
SCCL 2033
I don’t know how to do that.
Could anyone have an idea, Thanks in advance?
A
SCCL 1574
LC08199
KS03559
SC70341
SCCL 2033
LC08758
AB04291
KS04018
I want this field to split into 2 (Letter should be in separate and number separate). e.g
A B
SCCL 1574
LC 08199
KS 03559
SC 70341
SCCL 2033
I don’t know how to do that.
Could anyone have an idea, Thanks in advance?
Last edited: