Remove the first character only if it is a comma

Hi all

I have the following data in a column:

E1, E14, E28, E29
, E11
, E15, E30

I need to remove the first comma so that the data shows the following:
E1, E14, E28, E29
E11
E15, E30

I have tried using formula like =SUBSTITUTE(CO12,",",,1) and =REPLACE(CO8,1,1,"") but it doesn't work as it will remove the first comma in every cell such that my data becomes like this:
E1 E14, E28, E29
E11
E15, E30

I.e. the first cell removes the first comma and the 2nd and 3rd cell has a spacing in front.

Any one can help?

=============

Actually, the above data comes from this formula:
=IF($D5=$CE5,$D$3,"")&IF($F5=$CE5,", "&$F$3,"")&IF($H5=$CE5,", "&$H$3,"")

any idea if it helps to improve this formula at all??

=if(left(a1,1)=",",trim(right(a1,len(a1)-1)),a1)

This works on the posted samples:

=IF(LEFT(A2)=",",TRIM(MID(A2,2,100)),A2)

Or without 'trim'

Please Login or Register  to view this content.

As request:

Originally Posted by Pearlyn

Actually, the above data comes from this formula:
=IF($D5=$CE5,$D$3,"")&IF($F5=$CE5,", "&$F$3,"")&IF($H5=$CE5,", "&$H$3,"")
any idea if it helps to improve this formula at all??

I think this formula need to be improved to remove comma "," at the beginning, not to place another formula in other cell.
Donot testing, but try:

Please Login or Register  to view this content.

You're welcome. Thanks for the feedback!