I have a column in my excel sheet that list titles of service tickets. I need a formula that will display the following.
我的excel表中有一列列出了服务票据的标题。我需要一个显示以下内容的公式。
Example: Reader 121 not reading badges
示例：Reader 121无法读取徽章
Expected result in the adjacent cell: Display the text "Reader"
相邻单元格中的预期结果：显示文本“Reader”
If someone could point me in the right direction it would be much appreciated.
如果有人能指出我正确的方向，我将不胜感激。
1 个解决方案
#1
0
Assuming you need to extract the first word of the ticket, you could look for the first space in string position and then extract from left. Example (if "Display the text "Reader" is in B1) :
假设您需要提取故障单的第一个单词，您可以在字符串位置查找第一个空格，然后从左侧提取。示例（如果“显示文本”Reader“在B1中）：
=LEFT(B3;FIND(" ";B3))
Hope this helps
希望这可以帮助
#1
0
Assuming you need to extract the first word of the ticket, you could look for the first space in string position and then extract from left. Example (if "Display the text "Reader" is in B1) :
假设您需要提取故障单的第一个单词，您可以在字符串位置查找第一个空格，然后从左侧提取。示例（如果“显示文本”Reader“在B1中）：
=LEFT(B3;FIND(" ";B3))
Hope this helps
希望这可以帮助