Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi all,
Once again struck with an issue. Is there any way to split one cell (text) to data to multi columns (offcourse i know the command "text to columns", based on separator, after trying that i am writing this. As it was giving single column where there is no separator or different separator is given. Any Ideas would be greatly appreciated. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm not sure I understand what you have in your cells since any character
can be a separator. Can you show us some examples (vary them as much as possible) of what is in the cells and how you want them to be split apart? -- Rick (MVP - Excel) "Vijay DSK" wrote in message ... Hi all, Once again struck with an issue. Is there any way to split one cell (text) to data to multi columns (offcourse i know the command "text to columns", based on separator, after trying that i am writing this. As it was giving single column where there is no separator or different separator is given. Any Ideas would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
converting hyperlink to actual web address | Excel Discussion (Misc queries) | |||
Critical - Converting Single Column Address Data into Multiple Col | Excel Worksheet Functions | |||
name,address in same column different rows. How move to columns | Charts and Charting in Excel | |||
Transposing 4-row clumps of name and address in Column A to Columns A,B,C,D | Excel Worksheet Functions | |||
Separate address column to Five columns | Excel Worksheet Functions |