We can FIND the first comma and combine everything from the left of it to
everything from the right of it.

=LEFT(A1,FIND(",",A1)-1) & MID(A1,FIND(",",A1)+1,255)

--
Gary''s Student - gsnu200856


"JohnBlack" wrote:

Dear all, I'm having a little trouble with an excel sheet. It consist of 500
plus records with values in it. Because the author of the document it was
copied from made some error with placing the decimals I'm now stuck with some
cells where there are multiple comma's such as:

78,583,506199
84,831,029277
87,756,172853
10,758,322459

I'm looking for a way to remove the first comma. Find and replace obviously
doesn't work because that will replace all the commas . Does anyone know of a
way to only remove the first comma ?