| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
I want to split containt of a cell and copy in seprate cells
I want to split containt of a cell ( combination of text, date, number with
space between them) and copy in seprate cells. exactly a function that run reverce of Concatination Thanks Sima |
|
#2
|
|||
|
|||
|
In cell one use
=left(A1,N) where N is the number of characters you want in the first cell in Cell two use =right(A1,Len(A1)-N) this will work in N is constant for each cell you want to split If N is not constant and there is particular character you want to split at Say ":" use =left(A1,find(":",A1)-1) and =right(A1,len(A1)-find(":",A1)) "Sima" wrote: I want to split containt of a cell ( combination of text, date, number with space between them) and copy in seprate cells. exactly a function that run reverce of Concatination Thanks Sima |
|
#3
|
|||
|
|||
|
Make sure you have empty columns to the right then use datatext to columns
and space as delimiter Regards, Peo Sjoblom "Sima" wrote: I want to split containt of a cell ( combination of text, date, number with space between them) and copy in seprate cells. exactly a function that run reverce of Concatination Thanks Sima |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| On click, copy text into another cell - XL2K | Excel Worksheet Functions | |||
| Copy text from same cell on every sheet to title sheet? | Excel Discussion (Misc queries) | |||
| COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) | |||
| copy a cell value not its function | Excel Discussion (Misc queries) | |||
Linear Mode
