Seperating Data From one cell in to an other

[Gillian]

Hi

Can anyone Help me urgently!

I have an address in one field and i need to know how i
can seperate it in to different cells on the same row.

Many Thanks

gillian

 

[Paul Lautman]

Am I correct to assume that the "address" that you refer to is a building
address rather than a cell address?

If so, how are the elements of the address delimited?

 

[Gillian]

example of cell entry:

101 monton road, eccles, M30 5EF

I need to seperate these entries in to seperate cells in
order to merge on word.

 

[NH]

Select your data then on menu
Use data>text to column>
Then choose delimited>Next>Select comma
It will split your entry in three seaparate columns provided they are
separated by commas