i have a data on the a cell mostly numbers e.g 23456, 45678,
i was to spread this single numeric data into different column
for example the data in a cell is 23456
i want to separate them into 2 in one column, 3 in another , 4 ,5 ,6 like this
i have a data on the a cell mostly numbers e.g 23456, 45678,
i was to spread this single numeric data into different column
for example the data in a cell is 23456
i want to separate them into 2 in one column, 3 in another , 4 ,5 ,6 like this
Last edited by finoj2020; 04-20-2015 at 04:46 AM.
Data / Text To Columns
Use Fioxed width option and select the vertical line breaks for each character
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks