Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Un-Delimiting
If I find that I have a single cell with values delimited with | , how
could I split each value into new cells across columns so YES|NO|MAYBE in A1 would be "YES" in C1, "NO" in D1, "MAYBE" in E1 NO in A2 would be "NO" in C2 YES|NO|MAYBE|ALWAYS in A3 would be "YES" in C3, "NO" in D3, "MAYBE" in E3 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Un-Delimiting
Hi,
Select the data then data|Text to columns Select delimited Next Check 'other' and enter your delimiter in the other box Finish Mike "caveman.savant" wrote: If I find that I have a single cell with values delimited with | , how could I split each value into new cells across columns so YES|NO|MAYBE in A1 would be "YES" in C1, "NO" in D1, "MAYBE" in E1 NO in A2 would be "NO" in C2 YES|NO|MAYBE|ALWAYS in A3 would be "YES" in C3, "NO" in D3, "MAYBE" in E3 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Un-Delimiting
Great Solution!
Do you think there would be a way to do that within a formula? like =LEN($A$1)-LEN(SUBSTITUTE($A$1,"|",""))+1 to find the number of time "|" occurs and then do a midstring in C1 based on A1 to get everything up to the "|" and then do a midstring in C2 based on A1 to get everything up to the (2nd) next "|" ....and so on until the number of "|" occurances is met On Apr 30, 6:09*am, Mike H wrote: Hi, Select the data then data|Text to columns Select delimited Next Check 'other' and enter your delimiter in the other box Finish Mike "caveman.savant" wrote: If I find that I have a single cell with values delimited with | , how could I split each value into new cells across columns so YES|NO|MAYBE in A1 would be "YES" in C1, "NO" in D1, "MAYBE" in E1 NO in A2 would be "NO" in C2 YES|NO|MAYBE|ALWAYS in A3 would be "YES" in C3, "NO" in D3, "MAYBE" in E3 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy/paste from other application without delimiting it? | Excel Discussion (Misc queries) | |||
tab delimiting numbers | Excel Discussion (Misc queries) | |||
Delimiting and Formatting | Excel Discussion (Misc queries) | |||
Macro delimiting text if column has value | Excel Programming | |||
delimiting w/multiple delimiters? | Excel Discussion (Misc queries) |