Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
text to splitted and to be palced in appropriate column
You should ensure that you have blank columns to the right of your
data by inserting new columns if necessary. Highlight the column with the data in and do Data | Text-to-columns. The Wizard will guide you through - set delimited and "/" as the delimiter (without quotes). Note that the data will not always go into the correct column, so you may need to do some further manipulation by inserting cells to move the data across. Hope this helps. Pete On Sep 19, 12:00 pm, sakthivelarumugam wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF: 2 criteria: Date Range Column & Text Column | Excel Worksheet Functions | |||
To copy values in a column relevant to text in an adjacent column? | Excel Worksheet Functions | |||
Wrap text in column headers to fit text in column | Excel Discussion (Misc queries) | |||
How I can print full text bigger than column, in repeat column | Excel Discussion (Misc queries) | |||
One file splitted into worksheets | Excel Worksheet Functions |