Eliminate text after fifth comma

[andpia]

Hello forum members,

Could someone suggest a cell formula-based solution to eliminate any text after the fifth comma (as well as the last comma)?

I have a column with the following kind of data:

slgf, dkjs, sjfgsi, deg
sytfdzau, zeyfd, syfu, dgd, at, syufs, suuf
sute, stfd, gsid, du, atdd, dggol, yfzq, hg, arut
...

And I would like to get the following result:

slgf, dkjs, sjfgsi, deg
sytfdzau, zeyfd, syfu, dgd, at
sute, stfd, gsid, du, atdd
...

Many thanks!

AndPia

[DonkeyOte]

If the strings are in A1, A2 etc then:

B1: =LEFT(A1;FIND("@";SUBSTITUTE(A1;",";"@";5)&"@")-1)
copied down

(if @ is used within the strings then swap for an alternative character that does not appear within your strings)

[andpia]

Thanks DonkeyOte - quick reply and effective solution. Kudos!

Best

AndPia