Question on breaking on cell into three seperate |
| Robert Walker replied to Frank Sabella at 08-May-08 06:29 |
|
Smith, john g |
=LEFT(E23,SEARCH(",",E23)) |
=MID(E23,LEN(F23)+1,LEN(E23)-LEN(F23)-2) |
=RIGHT(E23,2) |
|
davidson, michael h |
=LEFT(E24,SEARCH(",",E24)) |
=MID(E24,LEN(F24)+1,LEN(E24)-LEN(F24)-2) |
=RIGHT(E24,2) |
Try this where you text lines are at e23 and e24
Allows 2 initials at the end---see formula on right |
|