Adding space to cell contents with both alphas and numbers.

[extrudebg]

My problem is quite simple. An export of addresses combined the directional indicator with the street name.

850 SMarket St instead of 850 S Market St

Is there a way to add a space between the first and second alphas of a cell without knowing how many numbers come before it? Any assistance would be greatly appreciated.

[Krishnakumar]

Hi,

May be..

=REPLACE(A1,FIND(" ",A1)+2,0," ")

[extrudebg]

Excellent...thanks!