Formula for summing addresses within a single cell

  • Thread starter Thread starter BW
  • Start date Start date
B

BW

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.
 
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
 
Back
Top