ExcelBanter - LEFT function-all to left of a comma?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - LEFT function-all to left of a comma? (https://www.excelbanter.com/excel-worksheet-functions/217386-left-function-all-left-comma.html)

Jennifer F

LEFT function-all to left of a comma?

How do I get all the characters in a text string that are to the left of a
comma?

joel

LEFT function-all to left of a comma?

=LEFT(A1,FIND(",",A1)-1)

"Jennifer F" wrote:

How do I get all the characters in a text string that are to the left of a
comma?

All times are GMT +1. The time now is 05:11 AM.