I want a formula to split data "052 089652" and to reorganize it as "089652/A052/9" in Google Sheets. The formula needs to add "A" to the start of "052", add a "9" at the end, keep the leading zero, if there is one and place "/" in between. Another example below:

Input: `125 896542`

Output:`896542/A125/9`

I can do it using SPLIT and CONCATENATE functions in different cells but it gets messy.

Is there a simpler "all in one formula" to do this?

## Best Answer

Assuming You provided a exact format of data,