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

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.

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

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


"connie" wrote:

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.

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

How about selecting the range
edit|Replace
what: (spacebar)
with: (leave blank)
replace all



connie wrote:

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.

--

Dave Peterson

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

I got the prompt that there was no data to be found..

"Dave Peterson" wrote:

How about selecting the range
edit|Replace
what: (spacebar)
with: (leave blank)
replace all



connie wrote:

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.

--

Dave Peterson

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

Using Dave's Method
In the find what: text box - enter space
In the Replace with - leave blank

range must be selected

"connie" wrote:

I got the prompt that there was no data to be found..

"Dave Peterson" wrote:

How about selecting the range
edit|Replace
what: (spacebar)
with: (leave blank)
replace all



connie wrote:

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.

--

Dave Peterson

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

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



connie wrote:

I got the prompt that there was no data to be found..

"Dave Peterson" wrote:

How about selecting the range
edit|Replace
what: (spacebar)
with: (leave blank)
replace all



connie wrote:

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.

--

Dave Peterson


--

Dave Peterson