How do I split a cell in half in excel 2019?
- 1 Answers
- 765 Views
- I also Faced
- E-Mail Answers
How do I split a cell in half in excel 2019?..
Answer / Rajnish Kumar Srivatsav
To split a cell into two halves in Excel, use the following formula:
1. Select the cell.
2. Type `=LEFT(A1, LEN(A1)/2)` to get the first half and `=RIGHT(A1, LEN(A1)/2)` for the second half.
| Is This Answer Correct ? | 0 Yes | 0 No |
More MS Excel Microsoft Interview Questions
What is the shortcut to insert cells in excel?
How do do a vlookup in excel?
How do you use range in excel?
How do I fix #ref error in excel?
How do I unhide columns in excel 2007?
How do I count days in excel?
What does ctrl f6 do in excel?
What is the maximum row limit in excel 2010?
How do I create a shared excel file?
How do I change scenario manager?
What is a spreadsheet and examples?
How do I use datedif function in excel?
MS Excel Microsoft 
