How do I insert a comma 10 characters to the left of a string of characters

[Wholden21]

Example
I have multiple addresses similar to the below. I need to insert a comma 10 spaces to the left (after the city) so that I can use the delimeted to break it out into separate columns for city, state, zip (there is currently no comma after city)

Cleveland oh, 45120
e Rutherford nj, 06034
Tecumseh ri, 06044

 

[Joe4]

Welcome to the Board!

Try this formula (for an entry in cell A1):

=LEFT(A1,LEN(A1)-10) & "," & RIGHT(A1,10)

 

[Wholden21]

Oh my gosh!!! That is perfect!!! Thank you sooooooo much!!!!

 

[Joe4]

You are welcome.
Glad I was able to help!

 

[Wholden21]

One other question … sorry - how do I convert that information now into actual "data" so that I can use the delimited function? Thank you

 

[Joe4]

Select the column with the formulas, do a Copy -> Paste Special -> Values and click enter.