Remove Spaces Before a Comma Only

[lucolem]

Hello all,
I'm looking for a formula to remove a space, if it exists, before a comma. For instance, I need "Golden Retriever,Dog" to be "GoldenRetriever,Dog". I need it to only remove the space before the comma because there will be spaces after the comma that need to stay there. And there won't always be a space; don't know if that makes a difference.

Any ideas? Thanks!

 

[Marcol]

Or maybe this if there are more than one space before the comma?

Excel Workbook
	A	B
2	Golden Retriever,Dog	GoldenRetriever,Dog
3	Golden Retriever,Dog is yellow	GoldenRetriever,Dog is yellow
4	Golden Retriever,Dog has 4 legs	GoldenRetriever,Dog has 4 legs
5	Greater Spotted Woodpecker,Bird lives in the woods	GreaterSpottedWoodpecker,Bird lives in the woods
Sheet1