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,
From India, Mumbai
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
From India, Calcutta
1Kindly 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
From India, Calcutta
Dear Asif, Use Left function or Right function as given in attached sample file. I hope this will solve your problem.
From India, Mumbai
From India, Mumbai
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:
From India, Delhi
From India, Delhi
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,
From India, Mumbai
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,
From India, Mumbai
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Advanced Excel 2003.pdf
152120-very-use ful-hr-manageme nt-software-bui lt-excel-psa-hr -manager-mainta in-payrrol-exce l-soft.zip
Competancy--exc el---mts___smts _289.xls