adspace


How do I split a number into another cell in excel?

Answer Posted / Giridhari Kumar Jha

To split a number into another cell in Excel, follow these steps:
1. Enter the formula `=TEXTSPLIT(A1, " ")` into the cell where you want to store the splitted value.
2. Replace `A1` with the cell containing the number you want to split.
3. Press Enter.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How much is excel for ipad?

714


What is left formula in excel?

685


What is wrap text in excel?

721


Which is latest version of excel?

722


Image result for how do I compare two columns in excel

668


Why can't I see the tabs on my excel spreadsheet?

724