Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
opposite of concatenate?
I have multiple unique identifiers (item) in each cell of a spreadsheet,
separated by a comma and space, and I need to find a way to separate them so there is only one identifier (item) per cell. Is that possible? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
opposite of concatenate?
If they use common "dividers" take a look at Data - Text to Columns, and use
a delimiter as first option. Then choose your delimiter(s) as appropriate. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "BrightHawk" wrote: I have multiple unique identifiers (item) in each cell of a spreadsheet, separated by a comma and space, and I need to find a way to separate them so there is only one identifier (item) per cell. Is that possible? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
opposite of concatenate?
On Tue, 25 Aug 2009 12:48:05 -0700, BrightHawk
wrote: I have multiple unique identifiers (item) in each cell of a spreadsheet, separated by a comma and space, and I need to find a way to separate them so there is only one identifier (item) per cell. Is that possible? Take a look at "Text to columns" that you find under "Data". Hope this helps / Lars-Åke |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
opposite of concatenate?
Study MID Formula and see if it is usful to you or not.
You could have given some example so others can exactly understand your requirement and study & answer. -- Regards, Pritesh "BrightHawk" wrote: I have multiple unique identifiers (item) in each cell of a spreadsheet, separated by a comma and space, and I need to find a way to separate them so there is only one identifier (item) per cell. Is that possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there an opposite function to "Concatenate" in Excel? | Excel Worksheet Functions | |||
Opposite to CONCATENATE function | Excel Worksheet Functions | |||
Opposite of Concatenate | Excel Worksheet Functions | |||
Opposite of Concatenate | Excel Worksheet Functions | |||
Need opposite of excel function CONCATENATE | Excel Discussion (Misc queries) |