G
Garry
Hi all, How can I remove the first space from the following Postcodes :
B 1 0FD or B 3 1GF
thanks Garry
B 1 0FD or B 3 1GF
thanks Garry
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
KARL DEWEY
Backup the database and try this --
IIF(Right(Left([Postcodes]),2),1)=" ", Left([Postcodes],1) &
Mid([Postcodes],3)
IIF(Right(Left([Postcodes]),2),1)=" ", Left([Postcodes],1) &
Mid([Postcodes],3)
K
KARL DEWEY
Too fast on post --
Backup the database and try this --
IIF(Right(Left([Postcodes]),2),1)=" ", Left([Postcodes],1) &
Mid([Postcodes],3), [Postcodes])
--
KARL DEWEY
Build a little - Test a little
Backup the database and try this --
IIF(Right(Left([Postcodes]),2),1)=" ", Left([Postcodes],1) &
Mid([Postcodes],3), [Postcodes])
--
KARL DEWEY
Build a little - Test a little
KARL DEWEY said:Backup the database and try this --
IIF(Right(Left([Postcodes]),2),1)=" ", Left([Postcodes],1) &
Mid([Postcodes],3)
--
KARL DEWEY
Build a little - Test a little
Garry said:Hi all, How can I remove the first space from the following Postcodes :
B 1 0FD or B 3 1GF
thanks Garry
G
Garry
Spot on Karl, thanks for your time. You have saved me hours of manual work.
cheers
cheers
KARL DEWEY said:Too fast on post --
Backup the database and try this --
IIF(Right(Left([Postcodes]),2),1)=" ", Left([Postcodes],1) &
Mid([Postcodes],3), [Postcodes])
--
KARL DEWEY
Build a little - Test a little
KARL DEWEY said:Backup the database and try this --
IIF(Right(Left([Postcodes]),2),1)=" ", Left([Postcodes],1) &
Mid([Postcodes],3)
--
KARL DEWEY
Build a little - Test a little
Garry said:Hi all, How can I remove the first space from the following Postcodes :
B 1 0FD or B 3 1GF
thanks Garry