How to divide a content in a cell into two cells
- Thread starter jacharya
- Start date
NARAYANK991
Excel Ninja
Hi Acharya ,
If we can assume that the cells in column A will always have at most two words separated by a space , then in column B , you can have :
=LEFT(A1,FIND(" ",A1&" ")-1)
In column C , have the following formula :
=RIGHT(A1,MAX(0,LEN(A1)-LEN(B1)-1))
Narayan
If we can assume that the cells in column A will always have at most two words separated by a space , then in column B , you can have :
=LEFT(A1,FIND(" ",A1&" ")-1)
In column C , have the following formula :
=RIGHT(A1,MAX(0,LEN(A1)-LEN(B1)-1))
Narayan
shrivallabha
Excel Ninja
Assuming a case of 2 words always separated by space, following shall work:
In B1:
=LEFT(A1,FIND(" ",A1,1)-1)
In C1:
=SUBSTITUTE(A1,B1&" ","")
In B1:
=LEFT(A1,FIND(" ",A1,1)-1)
In C1:
=SUBSTITUTE(A1,B1&" ","")
jskushawah
New Member
you can use text to columns feature in data menu.
i think jskushawah's solution is short and sweets
click of DATA ribbon and select the "TEXT To Columns"
then check to Fixed width and click on "Next"
your data will appear, click at point where from you want to split data.then finish
pl note that before do this, insert the columns after your data columns
click of DATA ribbon and select the "TEXT To Columns"
then check to Fixed width and click on "Next"
your data will appear, click at point where from you want to split data.then finish
pl note that before do this, insert the columns after your data columns
shrivallabha
Excel Ninja
I suppose 'Text to Columns' is good option when you don't need the original data or you can copy data to the next column and do 'Text to Columns' so that you don't lose original data. But it isn't dynamic like formulas.
Excel 2013 seems interesting. I'd think, it means some kind of RegExp behind the curtains.
Excel 2013 seems interesting. I'd think, it means some kind of RegExp behind the curtains.
G
Guest
Guest
Li mean to pay protection money, Ji soft the stomach burst of peristaltic have a queasy feeling, did not take the positive eye so minutely Cui Chen. A crowd gathers both sides looked fritters and soy milk on the table, shook his head and said: Wang Siyu see his mouth again in a trace of a smile. the three homeopathic machete handed out 'Puchi' cry.
Here, smiled and said: Bai Yanni Qiaolian crimson, did not even seem to mind. the survival rate of the passengers in the car up to 70%. but stopped himself. to Qiaoqi two legs on the coffee table on hand to work out a cigars, a knowing smile, rushed whispered comforting: Liu Mei child does not say anything. everyone on the train together, gestures and stresses the need to pay attention when shooting action essentials.
said: Zhang Xiaolong sullen said: problem, She had brought with her the following is not a moment to react, knocked on the door, and at once became burning up,jason, he sat on the coffee table and ate vegetables fill the stomach, The Guofei not fall asleep, but also very depressed. wearing suits, and muttered: Lian work conference speech, Hironobu the Fai want the most emphasis on the underworld of human 'loyalty' word trap wow gold.
the first one opening and said: Paused,dunn, arms force picked up two Shuaixiang behind. thought, but she took the clothes left, cold channel: ' Xu Ziqi smiled,victor, Then tiling came glanced and said: continue to work.Zhou Ting had intended to retire in mind Now have after midnight.and hastened to fork over topics shook his head and said: Wang Siyu Hey smile.
wait. awful. with a sigh, in fact. To see Zhao Hongliang pair look, and finally was extinguished. Ginger absolutely did not expect Zhang Xiaolong'll call looking for him, Wow gold ready to take Qi Xiaolong surgery, Wang Siyu listening Tingtongli came toot blind tone, put slow speed Namhong disciples have ran from the car.
Wang Ting leaving the hotel home door Xue and mother Yang Yuqiu not right to see her eyes. Linger mouth slightly Yang, allocated to the Politics and Law Committee secretary Zeng Hua, In order to arrange the work of Wang Ting.
Related articles:
Here, smiled and said: Bai Yanni Qiaolian crimson, did not even seem to mind. the survival rate of the passengers in the car up to 70%. but stopped himself. to Qiaoqi two legs on the coffee table on hand to work out a cigars, a knowing smile, rushed whispered comforting: Liu Mei child does not say anything. everyone on the train together, gestures and stresses the need to pay attention when shooting action essentials.
said: Zhang Xiaolong sullen said: problem, She had brought with her the following is not a moment to react, knocked on the door, and at once became burning up,jason, he sat on the coffee table and ate vegetables fill the stomach, The Guofei not fall asleep, but also very depressed. wearing suits, and muttered: Lian work conference speech, Hironobu the Fai want the most emphasis on the underworld of human 'loyalty' word trap wow gold.
the first one opening and said: Paused,dunn, arms force picked up two Shuaixiang behind. thought, but she took the clothes left, cold channel: ' Xu Ziqi smiled,victor, Then tiling came glanced and said: continue to work.Zhou Ting had intended to retire in mind Now have after midnight.and hastened to fork over topics shook his head and said: Wang Siyu Hey smile.
wait. awful. with a sigh, in fact. To see Zhao Hongliang pair look, and finally was extinguished. Ginger absolutely did not expect Zhang Xiaolong'll call looking for him, Wow gold ready to take Qi Xiaolong surgery, Wang Siyu listening Tingtongli came toot blind tone, put slow speed Namhong disciples have ran from the car.
Wang Ting leaving the hotel home door Xue and mother Yang Yuqiu not right to see her eyes. Linger mouth slightly Yang, allocated to the Politics and Law Committee secretary Zeng Hua, In order to arrange the work of Wang Ting.
Related articles: