text delimited

[sinkit]

Hello,

Anyone could help me instead of using text delimited is
there any formula that i can use

For example I want to separate the first word

column a column B must be
Sergio Osmena Ong Osmena Ong
Anna cruz Cruz
Carlos Chua ong Chua ong

What will be the formula for column B I only need the
first word or name in column A

Thanks.

 

[Frank Kabel]

Hi
have a look at 'Data - Text to columns'. also see
http://www.cpearson.com/excel/FirstLast.htm