Splitting text, like "Text to columns", but as a formula

Giganews Newsgroups
Subject: Splitting text, like "Text to columns", but as a formula
Posted by:  Chris Glen
Date: Thu, 4 May 2006

I have first names and last names in one column that I want to split into two
columns. A formula woul be more practical than using the "Text to columns",
as I'm constantly adding to the spreadsheet, and need to rapidly get the one
column and two column versions out of it. I know LEFT and RIGHT work well for
fixed length situations, so I'm hoping there's similar comand that uses a
delimiter.

Replies