ExcelBanter - Single Cell To more cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Single Cell To more cells (https://www.excelbanter.com/excel-discussion-misc-queries/257719-single-cell-more-cells.html)

Rohinikumar

Single Cell To more cells

hi,

some one can help me one more doubt in single cell much massage is there but
i want to devide that massage in more cells like below.

In Single Cell kum rakesh arun anand Gaurav

I want change in more Cells like this
A B C D E
kum rakesh arun anand Gaurav
is it Possible?

Max

Single Cell To more cells

Try Data Text to Columns Delimited Check "Space" Finish
Joy? hit YES below
--
Max
Singapore
---
"Rohinikumar" wrote:
some one can help me one more doubt in single cell much massage is there but
i want to devide that massage in more cells like below.

In Single Cell kum rakesh arun anand Gaurav

I want change in more Cells like this
A B C D E
kum rakesh arun anand Gaurav
is it Possible?

All times are GMT +1. The time now is 11:52 PM.