Snippets home page
 
 
register
 
 
computer

How do you split words in excel?

I need to split words in an excel cell.

asked by FrankShines (15)

You have 50 words left!
 
 
related questions

How do you make a new line character in a Microsoft Excel cell?

How do you create array using countif in Excel?

How do you merge your excel bar chart from two worksheets into the same workbook?

How do you perform the function in excel to use split cell by comma, when do you hit delimited?

What are Microsoft Words keyboard shortcuts in alphabetical order?

What is not enough system resource in Excel mean?

What should I know about viewing French words in Excel?

Tags:  computer  software

answers

Select_column A, From menu select Data,Text,Columns,Delimited click Next Under the Delimiters heading, make Space is selected, click Next, In Destination area, type $B$1, then click Finish.

4 votes

If you want to split the cells,Select col A and From menu, sel. Data & then Text to Col. &click Next & under the Delimiters heading click Next & Destination & type $B$1.

4 votes

Select column A -From the top menu, select Data and then Text to Columns -Select Delimited and click Next -Under the Delimiters heading, make sure only Space is selected and click Next -Under the Destination area, type your content and then click Finish

reply
posted by anbu (5965)
4 votes

type some words in A column. then Select column A. From the top menu, select Data menu and then Text to Columns option. Select Delimited and click Next. then Under the Delimiters heading, make sure only Space is selected and click Next. Under the Destination area, type $B$1 and then click Finish

3 votes

You can split the cells by following these steps: -Select column A -From the top menu, select Data and then Text to Columns -Select Delimited and click Next -Under the Delimiters heading, make sure only Space is selected and click Next -Under the Destination area, type $B$1 and then click Finish

reply
posted by mahes (32209)
3 votes

Report a post on this page as inappropriate
 If you have questions about user content, read our liability disclaimer

  
   
Add your own answer in 50 words or less! Add your comment in 50 words or less!

copyright © 2008
conjecture corporation

FAQ About Us Contact Us Terms & Conditions Privacy Policy