• 590K Members
• 4,954 Online
• 716K Conversations
SOLVED

Highlighted
New Contributor

# finding a specified word from the sentence in the cell and put in the other cell

Hello,

I have very long door specification table. In the attached file in the "A" column the specification of door is written as a sample. I want to see in the "B" column the material of door . I wrote by hand in the "B" column each of the doors material , but I want that excel take specified word from in the "A" column and writes by itself.

3 Replies
Highlighted
Solution

# Re: finding a specified word from the sentence in the cell and put in the other cell

Hi Mustafa,

That could be

`=MID(A2,SEARCH(" cm ",A2)+4,SEARCH("door",A2)-SEARCH(" cm ",A2)-5)`
Highlighted

# Re: finding a specified word from the sentence in the cell and put in the other cell

Hello Sergei,

Thank you, yes it works 1 exactly what I wanted. Thank you so much.

Honestly I may say that I didn't understand how it works this magical formula but really great :)

# Re: finding a specified word from the sentence in the cell and put in the other cell

How it works:

MID(A2, 12, 6) returns text which is in A2 starting from 12th positions and 6 characters length;

SEARCH(" cm ", A2) finds the position of the " cm " in A2. +4 gives where next word starts (since " cm " is 4 characters length). Let say it'll be 12.

SEARCH("door", A2) finds the position where "door" starts. Extracting from it previous result minus one we receive the length of the text to extract (let say 6).

Related Conversations
Word 365 svg import problem
Goupil35000 in Office 365 on
0 Replies
Page numbers won't start at 1
jamieschwenger in Office for Mac on
5 Replies
Deleting Sections in Word for the Mac
Bob_Irvine in Office for Mac on
0 Replies
Protected Word forms for assignments
Kylie66 in Word on
0 Replies
Documentation Migration
SunLeo in Office 365 on
0 Replies