S sdsurzh Member Mar 26, 2013 #1 Hi, How to find out the names alone from a line. Ex: 1. Senthil Kannan Ram working in abc company 2. vinoth kumar working in xyz company Now i want a formula to extract the names only for 1. Senthil Kannan Ram 2. vinoth kumar Any help. Thanks, SK
Hi, How to find out the names alone from a line. Ex: 1. Senthil Kannan Ram working in abc company 2. vinoth kumar working in xyz company Now i want a formula to extract the names only for 1. Senthil Kannan Ram 2. vinoth kumar Any help. Thanks, SK
Debraj Excel Ninja Mar 26, 2013 #2 Hi Suresh, Is the above line in a single cell.. By the way.. check the below and try to adjust accordingly.. I will be there for you if any help needed....!!! http://chandoo.org/forums/topic/help-4 Regards, Deb
Hi Suresh, Is the above line in a single cell.. By the way.. check the below and try to adjust accordingly.. I will be there for you if any help needed....!!! http://chandoo.org/forums/topic/help-4 Regards, Deb
A amrit1186 Member Mar 26, 2013 #3 Hi Suresh Looking at the number of posts from you it does not seem to be so simple, but in case the data is in single cell and the format remains tha same, you can use this in B column, assuming your data is in column A. =LEFT(A1,FIND("working",A1)-2)
Hi Suresh Looking at the number of posts from you it does not seem to be so simple, but in case the data is in single cell and the format remains tha same, you can use this in B column, assuming your data is in column A. =LEFT(A1,FIND("working",A1)-2)
