I'd like to be able to split multi-lined cells into rows using only 1 command.

I have tried using the command

=transpose(split(A2," "))

but when trying to add the 'tab' key as a custom separator it doesn't seem to allow me.

I've tried entering the words 'tab' 'shift' and 'enter' into this custom separator field but none seem to perform the desired function.

CUSTOM Separator

**Ideal beginning and end product**

1 Answer 1


Try to use the ASCII codes for Tab (#9) and the CHAR function, so that your formula would look like this:


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.