sharepoint - 从共享点列表中导出 excel，在查找中没有符号 #

Question

从 Sharepoint 列表中导出数据时，Lookup 类型的列会在原始数据前添加一个“#”。有什么办法可以去掉那个符号吗？

标签： sharepointsharepoint-2013export-to-excelsharepoint-online

Answer 1

It is by default. There is no way to remove "#" in front of the original values.

As a workaround, you can create a new Single of Line text column called Text01 in my sample, and use SharePoint Designer workflow to set its value to the values of the Lookup column like the below:

After that, go to the list settings, and modify the view and uncheck the lookup column under Columns section.

After the above, when you export the list using "Export to Excel", the result will be like: