Excel Expert Your Support Needed - Xls Download

Dear CiteHRian, I need a solution to ease my job. We have a database around 13000 There is a column with First and Last name in each cell. I want only the first name Kindly support, Regards,
24th June 2008 From India, Mumbai

Dear Asif,
Kindly let me know which version of MS office u are using. In ms office 2003 there is an option under "data" menu called "text to columns ". With this you can split a column by selecting it and then using the above option.
Rupa
24th June 2008 From India, Calcutta

Dear Asif, Use Left function or Right function as given in attached sample file. I hope this will solve your problem.
24th June 2008 From India, Mumbai

Attached Files (Download Requires Membership)

example.xls (13.5 KB, 307 views)

Dear Asif, Please find attached file. This formula will help you to split the names in First Name , Middle Name & Last Name. Regards, Amit Pawar:icon6:
24th June 2008 From India, Delhi

Attached Files (Download Requires Membership)

Split the Name - Formula.xls (13.5 KB, 508 views)

Dear All,
Thanks a lot for ur support and guidance.
Please find enclosed a sample data.
What I need now is
1. I want only the First name seperated from full name (you can note the first name ending is identified by space or capital letter)
2. I want only 10 digit of mobile numbers i.e presently i have a series of 91-99677298848 and i want 9967298848.
i am using MS 2007 version.
Thanks in Advance,
Regards,
24th June 2008 From India, Mumbai

Attached Files (Download Requires Membership)

sample data.xls (164.0 KB, 612 views)