How to extract a word from a sentence in a cell

D

devdutt_dev

hi,
there is a cell containing a sentence and one word is within doubl
quotes(" "). I am searching for a formulae that would extract th
"word" without the double quotes to another cell.

A1: "Desktop" Not able to switch on the computer

and i want

B2: Desktop

Please help me.
Thanks,

Devdut
 
D

duane

text containing "anything" in cell a12 - this is a little long

=MID(A12,FIND("""",A12),FIND("""",A12,FIND("""",A12)+1)-FIND("""",A12)+1
 
D

duane

sorry - this loses the """"'s

=MID(A12,FIND("""",A12)+1,FIND("""",A12,FIND("""",A12)+1)-FIND("""",A12)-1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extract all letters from a cell sentence 5
Find a word in a sentence 10
How to extract separated text by many commas in Excel? 0
How to extract a character from a string then VLOOKUP a table? 7
Extract Formula to Text 6
Finding Text in a cell 3
Find in a sentence diferent word 1
Need a macro to extract certain values / characters in a cell 2

Top