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

Hello,

Depending on the version of Excel what you are looking for is normally under the main heading of Data. The option is called "Text to Columns". You need to have an empty column to the right of the current column for every additional column ( in your case 1 column is needed). The highlight the column and use the Text to columns option and tell the wizard it is delimited and the character is the pipe (|).

Hi
yes its magic, its work
thanks rch1231
Regards

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.