Hi,
I've got a list of postcodes that I need to use in another formula, but there are spaces in odd places within the data that I need to remove. Is there a way of doing this?
Example:
NN 7 3AP
NN 4 7AA
NN 3 6AH
LU 4 9UJ
NN 3 6LR
NN 3 3JB
NN 2 7HG
I need to not have the space between the NN and the 7, but I'm happy to take out all spaces in the cell if that's easier.
Thanks!
Bookmarks