How can I remove a space between a letters and set of numbers?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In one cell I have a series of 4 letters than a space and series of 3-6
numbers, I'm looking for a shortcut to remove the space between them. My
spreadsheet contains several hundred that I need to adjust.
 
Using formulae only and the use of helper columns
1. separate the letters from the data
use formula =LEFT(X, 4) - where X = Your Data Cell

2 Separate the numbers
use the following
=RIGHT(X,LEN(X)-4) - where X = Your Data Cell

To add back together without the space.
=CONCATENATE(B1,C1) - where B1 = No.1 above & C1 = 2 above

HTH
 
How about selecting the range
edit|Replace
what: (spacebar)
with: (leave blank)
replace all
 
Using Dave's Method
In the find what: text box - enter space
In the Replace with - leave blank

range must be selected
 
Either you didn't select the correct range

or you had that "Match entire cell contents" option checked.

or that range didn't have a space character

maybe because....

If you copied from a web page, that space may not be a normal space
character--it could be one of those HTML non-breaking space characters.

Try:
select the range
edit|replace
what: alt-0160
(hit and hold the alt key while typing 0160 on the numeric keypad)
with: (leave blank)
replace all
 
Back
Top