Splitting information

  • Thread starter Thread starter Sid
  • Start date Start date
S

Sid

Hi and question,

There a formula that splits information in one cell into two cells. The
reverse of CONCATENATE.

Many thanks
Sid
 
Hi Sid!

You'll probably have to use a parsing formula of some kind

eg.

A1
Norman Harker
B1
=LEFT(A1,FIND(" ",A1)-1)
Returns: Norman
C1
=RIGHT(A1,FIND(" ",A1)-1)
Returns: Harker

You'll see that the main object will be to get a rule for determining
the division between the two parts of the information.

Also worth looking at will be:

Data > Text to Columns

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Or, if you want to permanently split the information, you can use
Data>Text to Columns.
 
Back
Top