Calculate content of a cell in excel

[Kevin Neufeld]

I have a table below. Column A represents the shipments that are consolidated into one single load. Is there a formula I can put in column B to automatically figure the number of shipments? each shipment is separated by a comma.

thanks

A	B
Shipment Number	Total Shipments
SHP001802820, SHP001803122, SHP001803362, SHP001803324, SHP001803491, SHP001803565, SHP001803602, SHP001803569, SHP001803613	9
SHP001808611	1
SHP001813687, SHP001814004, SHP001814257, SHP001814731	4
SHP001803965, SHP001807921	2

<tbody>
</tbody>

 

[SyedUsman]

=LEN(A2)-LEN(SUBSTITUTE(A2,",",""))+1

Assuming your shipment is in cell A2

 

[Kevin Neufeld]

That worked perfectly, thank you very much.