| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to split Cell content into two resulting cells
How do i split the content of a cell into two resulting cells without
splitting any words. I have a cell with 32 characters and I want to slip this and copy it into two resulting cells without splitting any words in the cell |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to split Cell content into two resulting cells
Assuming your phrase is in A1 and that there is a space between two of the
words, this will split after the 1st word. =LEFT(A1,FIND(" ",A1)-1) and for the other half =RIGHT(A1,LEN(A1)-FIND(" ",A1)) " wrote: How do i split the content of a cell into two resulting cells without splitting any words. I have a cell with 32 characters and I want to slip this and copy it into two resulting cells without splitting any words in the cell |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I split 1 cell into 2 cells in Excel? | Excel Discussion (Misc queries) | |||
| Split date in cell into 2 separate cells | Excel Discussion (Misc queries) | |||
| copying content of cell automatically to multiple cells | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Put an autoshape in a cell based on another cells content | Excel Worksheet Functions | |||
Linear Mode
