Remove ONE value from a cell?

[Jyggalag]

Hi all,

I am currently working with a data set that looks like this:

I would like a formula that takes all the values in column A, and if they begin with a comma (","), it should remove this

So the result should be like this:

Does anybody have a formula for this?

It would be greatly appreciated!

Thank you so much

Kind regards,
Jyggalag

 

[Joe4]

Try this:

=IF(LEFT(A1,1)=",",MID(A1,2,LEN(A1)-1),A1)

 

[Fluff]

How about

=IF(LEFT(A1)=",",REPLACE(A1,1,1,""),A1)

 

[Peter_SSs]

Based on your samples (no commas anywhere except at the start) ..

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

 

[Jyggalag]

How about

=IF(LEFT(A1)=",",REPLACE(A1,1,1,""),A1)

This works!!

Thank you so much Fluff!

Also everybody else @Peter_SSs and _Joe4

Very nice formula to have going forward, appreciate it guys Have a good one!

 

[Fluff]

Glad we could help & thanks for the feedback.