Look up a word within a sentence and copy into a next column
Closed
Erika
-
Feb 20, 2017 at 11:45 PM
Erika@83 Posts 1 Registration date Monday February 20, 2017 Status Member Last seen February 23, 2017 - Feb 23, 2017 at 02:42 AM
Erika@83 Posts 1 Registration date Monday February 20, 2017 Status Member Last seen February 23, 2017 - Feb 23, 2017 at 02:42 AM
Related:
- Look up a word within a sentence and copy into a next column
- Insert a tick in word - Guide
- How to search for a word on a page - Guide
- Number to text in word - Guide
- How to insert a line in word for resume - Guide
- Microsoft word free download - Download - Word processors
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Feb 21, 2017 at 05:48 AM
Feb 21, 2017 at 05:48 AM
Erika, Good morning.
Since you have not told us the layout of your spreadsheet, it's harder to conclusively help you.
But I'll try to help you.
Suppose this scenario:
Sheet1
A1:A10000 --> Your sentences
B1:B10000 --> FORMULA --> your future city names
Sheet2
A1:A200000 --> Data base of City Names.
Try to use:
Sheet1
B1 --> =LOOKUP(2^15, FIND(Sheet2!$A$1:$A$200000, A1), Sheet2!$A$1:$A$200000)
Copy it down.
Is that what yo want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Since you have not told us the layout of your spreadsheet, it's harder to conclusively help you.
But I'll try to help you.
Suppose this scenario:
Sheet1
A1:A10000 --> Your sentences
B1:B10000 --> FORMULA --> your future city names
Sheet2
A1:A200000 --> Data base of City Names.
Try to use:
Sheet1
B1 --> =LOOKUP(2^15, FIND(Sheet2!$A$1:$A$200000, A1), Sheet2!$A$1:$A$200000)
Copy it down.
Is that what yo want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Feb 22, 2017 at 10:49 AM
Feb 22, 2017 at 10:49 AM
Erika, Good afternoon.
Here is an small example of your data using my suggested formula:
https://www.sendspace.com/file/5i1ty1
In this case, the formula has been treated so that it does not display an error when no city is found in the sentence or the cell is empty.
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Here is an small example of your data using my suggested formula:
https://www.sendspace.com/file/5i1ty1
In this case, the formula has been treated so that it does not display an error when no city is found in the sentence or the cell is empty.
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Erika@83
Posts
1
Registration date
Monday February 20, 2017
Status
Member
Last seen
February 23, 2017
Feb 23, 2017 at 02:42 AM
Feb 23, 2017 at 02:42 AM
wow, thank you so much Mazzaropi, that is great! This is exactly what I was looking for!
Another question....it becomes a bit more difficult if there are two cities in the sentence...
e.g. - I'm going to Paris from Vienna - so let`s say I would want preference to be given the end word and only then display Vienna in the next column - is that possible?
Thank you for all your time and your help
Another question....it becomes a bit more difficult if there are two cities in the sentence...
e.g. - I'm going to Paris from Vienna - so let`s say I would want preference to be given the end word and only then display Vienna in the next column - is that possible?
Thank you for all your time and your help
Feb 21, 2017 at 03:37 PM
Thank you for trying anyway
All the best
Erika