Remove space before comma if exists

Hi,
Try this formula:

Formula:

Please Login or Register  to view this content.

Try this

=SUBSTITUTE(A1," ,",",")

Originally Posted by Crooza

Try this

=SUBSTITUTE(A1," ,",",")

Great minds think alike.....

Yep. It was the obvious solution wasn't it

Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

Hi Wholly,

Your data has 2 spaces before the comma so you can either use:

Formula:

Please Login or Register  to view this content.

or

Formula:

Please Login or Register  to view this content.

The second formula is better because it will fix up any cells where there is either 1 or 2 spaces before the comma

And that s why it is almost always better to upload a sample workbook - noway that was visible in the pic (which many members cannot even see anway)

Originally Posted by FDibbins

And that s why it is almost always better to upload a sample workbook - noway that was visible in the pic (which many members cannot even see anway)

Hmm, yes.... and there was only single spaces in the original post!