| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing hard returns
I have a cell with a complete address, spaced with a hard return:
555 Main Street Anywhere, USA 80101 And want the address to be separated to different cells. Any ideas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Removing hard returns
Select the cell and pull-down:
Data Text to Columns... Delimited Next check Other and in the character box touch CNTRL-j and then Finish -- Gary''s Student - gsnu200793 "Janet" wrote: I have a cell with a complete address, spaced with a hard return: 555 Main Street Anywhere, USA 80101 And want the address to be separated to different cells. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hard returns | Excel Discussion (Misc queries) | |||
| Removing carriage returns from excel | Excel Worksheet Functions | |||
| Hard returns in a formula? | Excel Worksheet Functions | |||
| how to remove hard returns, which show as little boxes | Excel Discussion (Misc queries) | |||
| Removing Hard Borders from Excel Spreadsheet | Excel Worksheet Functions | |||
Linear Mode
