如何在Excel中串联两个没有空间的单元格? [英] How to concatenate two cells without space in excel?

问题描述

我的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中串联两个没有空间的单元格?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！