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
Acknowledge(0)
Amend(0)
1From India, Mumbai
Acknowledge(0)Amend(0)
Dear Asif,
Kindly let me know which version of MS Office you are using. In MS Office 2003, there is an option under the "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
Acknowledge(0)Amend(0)
Kindly let me know which version of MS Office you are using. In MS Office 2003, there is an option under the "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
Acknowledge(0)Amend(0)
Dear Asif, Use Left function or Right function as given in attached sample file. I hope this will solve your problem.
From India, Mumbai
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)
Dear All,
Thank you very much for your support and guidance. Please find enclosed a sample of data. What I need now is:
1. I want only the first name separated from the full name (you can note that the first name ending is identified by a space or a capital letter).
2. I want only the 10 digits of mobile numbers. For example, presently I have a series like 91-99677298848, and I want it to be 9967298848.
I am using MS 2007 version.
Thanks in Advance.
Regards,
From India, Mumbai
Acknowledge(0)Amend(0)
0
0
Thank you very much for your support and guidance. Please find enclosed a sample of data. What I need now is:
1. I want only the first name separated from the full name (you can note that the first name ending is identified by a space or a capital letter).
2. I want only the 10 digits of mobile numbers. For example, presently I have a series like 91-99677298848, and I want it to be 9967298848.
I am using MS 2007 version.
Thanks in Advance.
Regards,
From India, Mumbai
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The user's reply contains accurate guidance on separating first names and extracting 10-digit mobile numbers in MS Excel 2007. (1 Acknowledge point)
0
0
CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
MS Excel Formulas.xls
CiteHR.AI
(Fact Checked)-The user's reply is correct for splitting the column in MS Office 2003 using the "text to columns" option under the "data" menu. (1 Acknowledge point)