Extracting data from a cell - please help
 

Hi all,

I have a column of cells of address data. The data contains house
number, street name, town and postcode. Is it possible to extract the
postcode from the line easily? and place it into another cell.

Thanks

Andrew


--
ajw150
------------------------------------------------------------------------
ajw150's Profile: http://www.excelforum.com/member.php...fo&userid=8020
View this thread: http://www.excelforum.com/showthread...hreadid=546623

Extracting data from a cell - please help
 

Hi Andrew

It does depend to an extent on how the string is formulated (ie are the
different elements separated by a delimiter such as a space or a comma)
and how consistent the structure is between different records (ie is it
always house number, street name, and town or may it sometimes be house
number, street name, district and town?). Assuming it is fairly
consistent and there is a delimiter such as a comma, then I would
suggest using DataTextToColumns and following the wizard prompts.

Does this help?

Richard


--
RichardSchollar
------------------------------------------------------------------------
RichardSchollar's Profile: http://www.excelforum.com/member.php...o&userid=34698
View this thread: http://www.excelforum.com/showthread...hreadid=546623

Extracting data from a cell - please help
 

Thanks, a great help. A simple but effective process. Thanks goodness
for commas.

Andrew


--
ajw150
------------------------------------------------------------------------
ajw150's Profile: http://www.excelforum.com/member.php...fo&userid=8020
View this thread: http://www.excelforum.com/showthread...hreadid=546623