harryas1998
New Member
- Joined
- Jul 22, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
For example
I have a list of 100 words in excel from A1 - A100
I need to use a formula to be able to output the words in a line with the Word "OR" in between
The output I would like would be is "word1 OR word2 OR word3 OR word4"
I believe this can be done using the text join Formular
Please help!
I have a list of 100 words in excel from A1 - A100
I need to use a formula to be able to output the words in a line with the Word "OR" in between
The output I would like would be is "word1 OR word2 OR word3 OR word4"
I believe this can be done using the text join Formular
Please help!
| Book1 | |||
|---|---|---|---|
| A | |||
| 1 | Amada | ||
| 2 | Athur | ||
| 3 | Aspic | ||
| 4 | Azali | ||
| 5 | Azoff | ||
| 6 | Baja | ||
| 7 | Beeston | ||
| 8 | Binham | ||
| 9 | Boldon | ||
| 10 | Bronze | ||
| 11 | Caju | ||
| 12 | Cantal | ||
| 13 | Cedgrave | ||
| 14 | Dardani | ||
| 15 | Drakensburg | ||
| 16 | Drommen | ||
| 17 | Ellington | ||
| 18 | Emerald | ||
| 19 | Fortana | ||
| 20 | Guna | ||
| 21 | Hawthorn | ||
| 22 | Indiana | ||
| 23 | Isari | ||
| 24 | Iseo | ||
| 25 | Kamet | ||
| 26 | Kimber | ||
| 27 | Ledro | ||
| 28 | Longhorn | ||
| 29 | Lugano | ||
| 30 | Merganser | ||
| 31 | Naresnsi | ||
| 32 | Nene | ||
| 33 | Pali | ||
| 34 | Peasemore | ||
| 35 | Penguin | ||
| 36 | Raven | ||
| 37 | Rhea | ||
| 38 | Rosslyn | ||
| 39 | Rumpless | ||
| 40 | Simien | ||
| 41 | Spey | ||
| 42 | Syraki | ||
| 43 | Turnmill | ||
| 44 | Virgil | ||
| 45 | Vranac | ||
| 46 | Walstead | ||
| 47 | Whistler | ||
| 48 | Windsor | ||
| 49 | Wissahickon | ||
| 50 | Wootton | ||
| 51 | Wroxham | ||
| 52 | Yared | ||
| 53 | Yatton | ||
| 54 | Yellowstone | ||
| 55 | Ardmore | ||
| 56 | Arklet | ||
| 57 | Aspic | ||
| 58 | Baja | ||
| 59 | Bayfront | ||
| 60 | Beechwood | ||
| 61 | Beeston | ||
| 62 | Boldon | ||
| 63 | Brancaster | ||
| 64 | Brie | ||
| 65 | Cabernet | ||
| 66 | Caju | ||
| 67 | Cortex | ||
| 68 | Dardani | ||
| 69 | Drommen | ||
| 70 | Duxton | ||
| 71 | Ellington | ||
| 72 | Emerald | ||
| 73 | Geki | ||
| 74 | Gessi | ||
| 75 | Hashiji | ||
| 76 | Hawthorn | ||
| 77 | Hulme | ||
| 78 | Indiana | ||
| 79 | Kai | ||
| 80 | Kamet | ||
| 81 | Lakehouse | ||
| 82 | Lomond | ||
| 83 | Longhorn | ||
| 84 | Manyunk | ||
| 85 | Manchego | ||
| 86 | Maypole | ||
| 87 | Mimongo | ||
| 88 | Minion | ||
| 89 | Mitumba | ||
| 90 | Morse | ||
| 91 | Narensi | ||
| 92 | Ness | ||
| 93 | Odyssey | ||
| 94 | Oracle | ||
| 95 | Orchard | ||
| 96 | Peasemore | ||
| 97 | Penguin | ||
| 98 | Pignolo | ||
| 99 | Rattlesdean | ||
| 100 | Rhea | ||
Sheet1 | |||
