Hi,
Assuming that all addresses are separated by commas (and there are no other
commas), use the following. Cell B25 holds the addresses.
=(LEN(B25)-LEN(SUBSTITUTE(B25,",","")))+1
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"BW" wrote in message
...
I need a formula that will sum the number of addresses listed in a cell.
An
example of how they are entered is:
2550 Elm, 100 Main, 475 Maple, 702 Twin Oaks
There could be any number from 1 to 50 addresses in any given cell.
I'm using Excel 2003.