"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
>
>
"Peo Sjoblom" wrote:
>
> Sorry Peo should read separated by a comma
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" <[email protected]> wrote in message
news:[email protected]...
>
>
> "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
>
>>
>>
what is the original data locations, example. You have to describe
exactly what you have, and what you want. However you will probably
find what you need to answer your question in
http://www.mvps.org/dmcritchie/excel/join.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"varun" <[email protected]> wrote in message news:[email protected]...
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks