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**

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

=transpose(split(A2,CHAR(9)))

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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