These tips and tricks are to help you improve your Excel usage efficiency and productivity.
Alt + Enter: force the text wrap in a cell.
Shift + Enter: insert a newline in a cell.
TEXTSPLIT function splits text strings by using column and row delimiters.
Example
Split the array constants in A2 into a 2X3 array.
Data
1,2,3;4,5,6
Formulas
=TEXTSPLIT(A2,",",";")
The following illustration shows the results.
© 2024 Digcode.com
