Need to split a group of up to 15 characters to be in a specfic cells.
An example of what would need to b esplit up would be the following:
ASJ-Z61-123456-714
Need it to be in the following Format:
Letters | Number | Number | Number | Number | Numbers | Number| Number
Only or letter or letter
symbol | company | market | ledger | sub region | serial/Account Number | Number | Year
AS | J | Z | 6 | 1 | 123456 | 71 | 4
I am just not sure what function or formula that I need to use.
Thank you for the help
Bookmarks