问题描述
我的excel工作表中有两列:
I have two columns in my excel sheet like that:
1234 | 548
21596 | 1875
当我通过执行 = A1& B1 来连接这两个字段时，它将给我 1234 548 ，两个值之间有空格.
When i concatenate this two field by doing =A1&B1 then it give me 1234 548 with space between the two values.
为什么要放置空格，如何删除?它用于填充数据库，因此我不想在值之间留空格.有什么想法吗?
Why it put a space and how can I erase it? It's for populate a database, so I don't want a space between my values. Any ideas please?
推荐答案
您可能只是在第二个值之前或第一个值后面有一个多余的空间，从而获得了一个空间.但是您可以使用 TRIM()函数删除空格.
You probably just have an extra space before your second values or behind your first values, causing you to get a space. But you can use the TRIM() function to delete spaces.
=TRIM(A1)&TRIM(B1)
好像您是法国人一样，这是链接到 SUPPRESPACE()函数.
Seen as though you're French, here's the link to the SUPPRESPACE() function.
=SUPPRESPACE(A1)&SUPPRESPACE(B1)
这篇关于如何在Excel中串联两个没有空间的单元格?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！