Hello,

Could someone please advise on how to format text & numbers in the same cell
as shown below:

I want the following format as shown in the examples given:

Example 1: 019 APR
Example 2: 530 OCT

The user may enter the information in a number of ways as shown in the
examples shown below:

Example 1: 019APR
Example 2: 19APR
Example 3: 019 APR
Example 4: 19 APR

Any help would be greatly appreciated,

Kind regards,

Chris.