# post code on col1 & list of suburbs in col2 - what is the formula

3. ## RE: VLOOKUP

"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
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

>
>

4. ## RE: VLOOKUP

"Peo Sjoblom" wrote:

>
> Sorry Peo should read separated by a comma

5. ## Re: VLOOKUP

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

"varun" <varun@discussions.microsoft.com> wrote in message
news:6DA93524-30B0-4E32-9313-291CCE8B4FCD@microsoft.com...
>
>
> "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
> 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
>
>>
>>

6. ## Re: post code on col1 & list of suburbs in col2 - what is the formula

what is the original data locations, example. You have to describe
exactly what you have, and what you want. However you will probably
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" <varun@discussions.microsoft.com> wrote in message news:85F53BF1-98CD-4A8E-8FA8-E8725C93C012@microsoft.com...
>