ExcelBanter - to split the cell containt

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

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

- - to split the cell containt (https://www.excelbanter.com/excel-discussion-misc-queries/138699-split-cell-containt.html)

anil

to split the cell containt

hi all,

I have a column with 100 enteries....the entries are as "abc sdf sdsd"
here i would like to copy tthis cell entities in to next three cells
by spliting at space between two words

Toppers

to split the cell containt

Look at Data=Text to Columns.

"anil" wrote:

hi all,

I have a column with 100 enteries....the entries are as "abc sdf sdsd"
here i would like to copy tthis cell entities in to next three cells
by spliting at space between two words

All times are GMT +1. The time now is 04:26 AM.