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



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

Answer / 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

More MS Excel Microsoft Interview Questions

How do you split a cell?

1 Answers  


What is a range in excel?

1 Answers  


How to compare two columns and return values from the third column in excel?

1 Answers  


How do I link cells in different excel workbooks?

1 Answers  


What is ctrl s in excel?

1 Answers  


Where is autosum in excel?

1 Answers  


What is conditional formatting excel?

1 Answers  


Can python work with excel?

1 Answers  


What is the difference between excel and a database?

1 Answers  


How can I create a table in excel?

1 Answers  


How do you merge cells in excel ios?

1 Answers  


How do I remove infinite rows in excel 2016?

1 Answers  


Categories