How to Adding One Space After String

[muhammad susanto]

hi all...

i'm looking for excel formula to add one space after string "JL."
please, check this below sample :

JL.text ----- JL. text
JL. text----- JL. text

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]col/row[/TD]
[TD]data (col.F)[/TD]
[TD]after formula[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]JL.HANG TUAH KP. KELAPA NO 38 SAIL[/TD]
[TD]JL. HANG TUAH KP. KELAPA NO 38 SAIL[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]JL. KEMUNING GG MESJID NO 30A SENAPELAN[/TD]
[TD]JL. KEMUNING GG MESJID NO 30A SENAPELAN[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]JL.BUNGA HARUM 7 HARJOSARI/SUKAJADI[/TD]
[TD]JL. BUNGA HARUM 7 HARJOSARI/SUKAJADI[/TD]
[/TR]
[TR]
[TD]etc..[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

any helps, much appreciated..

m.susanto

 

[mole999]

is it always JL.
is it always after the first .
is it always three characters

 

[muhammad susanto]

is it always JL.
is it always after the first .
is it always three characters

of course yes...

 

[mole999]

so you could do a simple FIND / REPLACE "JL." to "JL. " or build a substitute string

 

[muhammad susanto]

so you could do a simple FIND / REPLACE "JL." to "JL. " or build a substitute string

mole999, thank you..that's simple way out..