| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
separate text into multiple cells when there is ", "
I have address, city, province, postal code all in one cell (A1)
Can I split that into 4 cells containing address city province postal code (A1-D1) XL 2003 ....Lisa |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
separate text into multiple cells when there is ", "
Use the Text to Columns feature.
Make sure cells B1:D1 are empty. Any data in them will be overwritten. Select cell A1 Gotot the menu DataText to Columns Select DelimitedNext Select CommaFinish Biff wrote in message ups.com... I have address, city, province, postal code all in one cell (A1) Can I split that into 4 cells containing address city province postal code (A1-D1) XL 2003 ...Lisa |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
| "Control" plus "click" doesn't allow me to select multiple cells | New Users to Excel | |||
| freeze window creates multiple "views" suffixed with ":n" | Excel Discussion (Misc queries) | |||
| cells formatted to tick when text value "Y" if or null if "N" | Excel Discussion (Misc queries) | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
Linear Mode
