| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Separate Cells
I have 2 sets of numbers in a single cell, separeated by brackets
Eg (123) (456) I want to Separate them into individual cells using a formula, how do I do so? Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Separate Cells
If you have more set of numbers within brackets separated by space. the use
DataText to columnsSpace delimiter.. which will put that into separate columns..Once done replace the brackets.. If this post helps click Yes --------------- Jacob Skaria "PL" wrote: I have 2 sets of numbers in a single cell, separeated by brackets Eg (123) (456) I want to Separate them into individual cells using a formula, how do I do so? Thank you |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Separate Cells
Do you want to keep the ( ) ?
Are the numbers *always* 3 digits? Will the numbers ever have leading 0s like 012 ? -- Biff Microsoft Excel MVP "PL" wrote in message ... I have 2 sets of numbers in a single cell, separeated by brackets Eg (123) (456) I want to Separate them into individual cells using a formula, how do I do so? Thank you |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Separate Cells
With the number in A1 (123) (456); try
in B1 =SUBSTITUTE(LEFT(A1,FIND(")",A1)-1),"(",)+0 in C1 =SUBSTITUTE(MID(A1,FIND(" ",A1)+2,10),")",)+0 If this post helps click Yes --------------- Jacob Skaria "PL" wrote: I have 2 sets of numbers in a single cell, separeated by brackets Eg (123) (456) I want to Separate them into individual cells using a formula, how do I do so? Thank you |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Separate Cells
Thanks.
After experimenting it once, all the paragraphs I paste onto the excel worksheet is separated into columns? How to resolve this? Thanks "Jacob Skaria" wrote: If you have more set of numbers within brackets separated by space. the use DataText to columnsSpace delimiter.. which will put that into separate columns..Once done replace the brackets.. If this post helps click Yes --------------- Jacob Skaria "PL" wrote: I have 2 sets of numbers in a single cell, separeated by brackets Eg (123) (456) I want to Separate them into individual cells using a formula, how do I do so? Thank you |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Separate Cells
Excel annoyingly remembers the last setting for Text to Columns.
Pick some dummy data and run T to C with no delimiters to reset to neutral. Then paste your new paragraphs. Gord Dibben MS Excel MVP On Mon, 15 Jun 2009 23:41:02 -0700, PL wrote: Thanks. After experimenting it once, all the paragraphs I paste onto the excel worksheet is separated into columns? How to resolve this? Thanks "Jacob Skaria" wrote: If you have more set of numbers within brackets separated by space. the use DataText to columnsSpace delimiter.. which will put that into separate columns..Once done replace the brackets.. If this post helps click Yes --------------- Jacob Skaria "PL" wrote: I have 2 sets of numbers in a single cell, separeated by brackets Eg (123) (456) I want to Separate them into individual cells using a formula, how do I do so? Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| separate two dates from a text string into two separate cells | Excel Discussion (Misc queries) | |||
| Is there a way to separate into own cells? | New Users to Excel | |||
| Elapsed time when separate cells contain time and separate date | New Users to Excel | |||
| Separate first and second name in one cell into separate cells. | Excel Discussion (Misc queries) | |||
| Separate first and second name in one cell into separate cells. | Excel Discussion (Misc queries) | |||
Linear Mode
