Sorry, I don't understand your question, same postcode in all rows?

can you give an example like


postcode sub
postcode sub
postcode sub
postcode sub
postcode sub

--
Regards,

Peo Sjoblom

(No private emails please)


"varun" wrote in message
...


"Peo Sjoblom" wrote:

Hi Peo
sorry,it did not
'll review the question - may be u can give me a formula
1. row1 -10 contain same post code number
2. row 1-10 contains names of the various post code
3.can you please help me with a formula where single post code combines
all
the suburbs in a cell separated by a formula
4. please note that number of suburbs (text) in a single post code varies
need ur help
thanks

varun