Splitting Data

[Silvermini63]

I have data I need to separate out. It has the customer name, address and postcode all in one cell
E.G. in A2 I have mongrel dogs123 First Street5100
I need it to be (A2) mongrel dogs (B2)123 Frist Street (B3)5100

The issue is the text lengths are all different so using text to columns or spaces doesn’t work as some have it and some don’t

I am wondering if there is a formula that I could use that will find the street number after the customer name and split that out and so on with the postcode?

 

[venkat1926]

How can computer (nothing but a high speed idiot) recognise the name,address and perhaps pin code.. Are names two words or it can be one two or more words. can the last pin code be only one word. are there constant number of words in address.

 

[hiker95]

Silvermini63,

What version of Excel are you using?

You will generally get much more help (and faster) in this forum if you can post your small samples (what you have and what you expect to achieve) directly in the forum.

To attach screenshots, see below in my Signature block: Post a screen shot with one of these:

 

[lhen054]

Hi, i have the same issue.. i am working in an advertising company... and daily i need to extract an excel from a software called statex where i'd get the time that our ads appeared. However, the date; day; and time are all in one cell... and all i need is just the time. below is the screen shot of the excel:

http://www.flickr.com/photos/57503153@N02/6149415417/

i was told to use the forula =MOD(CELL,1) but am getting this below error.

http://www.flickr.com/photos/57503153@N02/6149415483/

can anyone please help me too?

 

[venkat1926]

lhen054
if you have entered as an excel date you can format as time

qustion is why you want this ?