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

VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
How to bulk add section breaks after a particular combination of letters/numbers 0
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Extract all letters from a cell sentence 5
How to pull certain words from a cell 1
Extract Month and year from Cell containing date, month, year & time 2
Need a macro to extract certain values / characters in a cell 3
Macro to extract few values from a cell 4

Top