Thread: Moving post code data to a different column
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Harish Mohanbabu[_3_] Harish Mohanbabu[_3_] is offline
external usenet poster
  
Posts: 10
Default Moving post code data to a different column
Hi,

Thanks for your replies :)

Norman - to answer your queries -
1) yes - all records contain postcode
2) no - postcode is always not the last field. In some records, they are in
2nd column and in some they are in 3rd column and so on
3) they don't have fixed format. To give you some examples -
AB24 5QH, DY8 3HX, IG19JX etc

Toppers,
A daft question. I am not clear on the following -
- how to implement this solution
- also I don't understand certain what do you mean when you say 'Lastrow'.
Could you elaborate on this please.

Thanks in advance,

Harish Mohanbabu
--
MBS Axapta - MVP
http://www.harishm.com/
Reply With QuoteReply With Quote