formula to separate text

  • Thread starter Thread starter Fernando Gomez
  • Start date Start date
F

Fernando Gomez

Having a cell A1 with this text:
Gomez....Fernando...Cost accountant
How can I get this content broken in 3 different cells as follow:
A2 = Gomez
A3 = Fernando
A4 = Cost Accountant

Your help is much appreciated.

Fernando
 
Fernando

It depends on what there is to distinguish the end of one section and the
beginning of the next. If it's a space, or a comma (or similar), try Data /
Text to columns.
Post back if it's more complex than that!

Andy.
 
Hi
try the following (if '...' indicates the end of each entry -> your
example is not that clear for this delimiter):
A2:
=LEFT(A1,FIND("...",A1)-1)
A3:
=MID(A1,FIND("...";A1)+3,FIND("...",A1,FIND("...",A1)+3)-FIND("...",A1)
-3)
A4:
=MID(A1,FIND("...",A1,FIND("...",A1)+3)+3,255)
 
Back
Top