space after cama

[SBAY3I]

hi all members,
which formula make space after cama, column in the left is original data, and the colomn in the right is what i want to do

123,325,551,555,525,875,219,7514	123, 325, 551, 555, 525, 875, 219, 7514
123,325,551,555,525,875,219,7514	123, 325, 551, 555, 525, 875, 219, 7514
123,325,551,555,525,875,219,7514	123, 325, 551, 555, 525, 875, 219, 7514

<tbody>
</tbody>

 

[mikeross]

You can highlight your data and click replace (press control + h). Then put a comma in the top and put a comma and a space in the bottom and then click replace all

 

[sericom]

=substitute(a1,",",", ")

 

[SBAY3I]

thank you very much mikeross

You can highlight your data and click replace (press control + h). Then put a comma in the top and put a comma and a space in the bottom and then click replace all

 

[SBAY3I]

thank you very much,
but didnt work with me

=substitute(a1,",",", ")

 

[SBAY3I]

=SUBSTITUTE(A1;",";", ") also this one working with me

=substitute(a1,",",", ")

 

[Macropod]

Cross-posted at: https://www.excelforum.com/excel-general/1240218-space-after-cama.html
Please read Mr Excel's policy on Cross-Posting in rule 13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html