English 中文(简体)
无法看到空间Excel Excel
原标题:Excel Space cannot be seen
  • 时间:2012-05-23 11:48:59
  •  标签:
  • excel

我从翻译.google.com 复制了一些名字。 然后我把它贴在了优异的上( 每一个名字在一列中) 。

现在,当我想将它分割为仅保留名字时,它不起作用。看起来优异的人再也看不到空间了。

我用了这个代码:

=LEFT(R2;SEARCH(" ";R2;1))
最佳回答

您需要使用逗号 (,) 来分隔公式中的变量, 所以像这样 :

=LEFT(R2,SEARCH(" ",R2,1))

那有帮助吗?

如果没有,请同时张贴单元格 R2 的内容。

问题回答

暂无回答




相关问题
import of excel in SQL imports NULL lines

I have a stored procedure that imports differently formatted workbooks into a database table, does work on them then drops the table. Here is the populating query. SELECT IDENTITY(INT,1,1) AS ID ...

Connecting to Oracle 10g with ODBC from Excel VBA

The following code works. the connection opens fine but recordset.recordCount always returns -1 when there is data in the table. ANd If I try to call any methods/properties on recordset it crashes ...

Excel date to Unix timestamp

Does anyone know how to convert an Excel date to a correct Unix timestamp?

C# GemBox Excel Import Error

I am trying to import an excel file into a data table using GemBox and I keep getting this error: Invalid data value when extracting to DataTable at SourceRowIndex: 1, and SourceColumnIndex: 1. As ...

Importing from excel "applications" using SSIS

I am looking for any tips or resources on importing from excel into a SQL database, but specifically when the information is NOT in column and row format. I am currently doing some pre-development ...

热门标签