how to format postcode in excell to remove the space? ie BB77 9EQ.

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

Guest

I have imported some postcode into excel and have different formats
B77 9EQ and ST17 1ED - I need to remove the space between - I have tried TRIM
 
Hi

Select the column with imported codes, and replace all spaces with nothing
(Edit.Replace window, use ReplaceAll). When spaces aren't replaced, then
likely you have 'hard spaces' there - try to copy some space from some cell
into SearchFor field of Replace window.


--
Arvi Laanemets
(When sending e-mail, use address arvil<At>tarkon.ee)


amanda Edwards said:
I have imported some postcode into excel and have different formats
B77 9EQ and ST17 1ED - I need to remove the space between - I have tried
Click to expand...
TRIM
 
Amanda

Use Find and Replace
Find " " (that is a space)
Replace with "" (dont put anything there)
I would suggest working through individually with Next - Replace - Next etc
as you will find that if you "Replace All" you may remove spaces you want
retained.

Cheers
Don


amanda Edwards said:
I have imported some postcode into excel and have different formats
B77 9EQ and ST17 1ED - I need to remove the space between - I have tried
Click to expand...
TRIM
 
Back
Top