ExcelBanter - remove space BE 039 to BE039

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - remove space BE 039 to BE039 (https://www.excelbanter.com/new-users-excel/260370-remove-space-039-be039.html)

Bobby Sullivan

remove space BE 039 to BE039

How can I remove the space in BE 039 to make it BE039?

Gord Dibben

remove space BE 039 to BE039

Have you tried EditReplace?

Gord Dibben MS Excel MVP

On Wed, 31 Mar 2010 10:49:02 -0700, Bobby Sullivan <Bobby
wrote:

How can I remove the space in BE 039 to make it BE039?

Russell Dawson[_2_]

remove space BE 039 to BE039

How about

=SUBSTITUTE(A1," ","")

--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.

"Bobby Sullivan" wrote:

How can I remove the space in BE 039 to make it BE039?

All times are GMT +1. The time now is 01:12 AM.