Thread: text to splitted and to be palced in appropriate column
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sakthivelarumugam sakthivelarumugam is offline
external usenet poster
  
Posts: 1
Default text to splitted and to be palced in appropriate column
1. susan/maen villa/washington-dc/us/234454
2.ameer/bigstrret/india/89787
3.vihas/mumbai/india/355345

These are the texts with 1. name/street/city/country/zipcode
2.name/street/country/code
3.name/city/country/cose

Actually I need to spilit those texts and to be placed in appropriate column.

Note:I have the predetermined lists of street/city/country/code.
Reply With QuoteReply With Quote