Formula to remove entries after comma

Hi all,

I was wondering whether there is a formula to remove any other entries in a cell, after comma; see below:

Col A Col B Col C
1, 12, 13 1
0,11, 12 0
A,B,C A
D,E,F D


One way is to do it via Data/ Text to Columns, but in this case you get the after comma entries populated in the cells to the right, is there any formula for the above so that the entries after comma get deleted?

Thx,
D

try:

=LEFT(A1,Find(",",A1)-1)+0

populated in the cells to the right

This can be avoided. In the last screen of the wizard you can select " do not import column"

Good point, if indeed all cells contain the same low number of comma separated values. If you have varying number of comma separated values and if there are some cell that contain many, then it becomes a drag to use text to columns... but still probably doable.

From PM:

Hi there,

A few days ago you helped me with the below formula

LEFT(A1,Find(",",A1)-1)+0

However, it gives back an error msg, when in one cell I have only one entry (ie there are no myltiple entries, only one, thus no commas). Do you know how to solve this?

Thank you very much,

You can use instead: =IF(ISNUMBER(FIND(",",A1)),LEFT(A1,Find(",",A1)-1)+0 ,A1)