Microsoft excel how to split text from one cell to two separate cells?

preview_player
Показать описание
How to split text from one cell to two separate cells?

Text: Khalid Mahmood

Left part of text: Khalid
Formula: text up to space position – 1

Right part of text: Mahmood
Formula: Length of text – text up to space position

Рекомендации по теме
Комментарии
Автор

I love to watch such excel skills, thanks.

camberlight