Hi everyone
I have an excel sheet and in this sheet i have a column with plain text data in list..
the data is just like (sample)
123131 | 564656311
85463 | 965132
3257| 93154911235
I need to create two columns from this column..
1. i need to convert data before |
2. i need to convert data after |
i think i explain what i m saying about..
thanks
waiting