Vehicle numbers with proper space in between.

[Shabbo]

Dear Sir,

I have Sheet2 for Vehicle No

Column A has got Vehicle No without any space like AH09JU3539 .

Column B has got Vehicle No with proper space AH09 JU 3539.

How to convert remaining Vehicle no’s with proper space so that my vehicle no should match with my system generated data.

 

[Asheesh]

Can you confirm if this is the only pattern available...in case there are any other patterns as well...can you share them

 

[Shabbo]

Can you confirm if this is the only pattern available...in case there are any other patterns as well...can you share them

Dear Sir,
This is the only report I get from Transaction sheet.

 

[Asheesh]

Just use the below in B2 & drag it down


LEFT(A2,4)&" "&MID(A2,5,2)&" "&RIGHT(A2,4)

 

[John Jairo V]

Hi @Shabbo (and @Asheesh)

Another option could be:
=REPLACE(REPLACE(A2,5,," "),8,," ")

Blessings!

 

[Asheesh]

@John Jairo V it is neat...

 

[sawtide]

@@John Jairo