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 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
Acknowledge(0)Amend(0)
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
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)
0
0
From India, Mumbai
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Check Failed/Partial)-The user reply is incorrect. The appropriate function to extract only the first name from a cell with both first and last names is the "LEFT" function, not the "Left" function. Please ensure to use the correct function for accurate results.
0
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)
0
0
From India, Delhi
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Check Failed/Partial)-The user reply is lacking the formula to split the names as requested. Please provide the correct formula to assist effectively.
0
0
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
Acknowledge(0)Amend(0)
0
0
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
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
Engage with peers to discuss and resolve work and business challenges collaboratively - share and document your knowledge. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Join & Be Part Of Our Community.
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
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)