Hello everyone,

I am trying to format a column to recognise the post code in a set
format, the way the data is coming is in this format CF32-7, but I
would like to omit the - sign, so it looks like CF32 7.

Is this possible?

Many thanks

Clash


--
Clash
------------------------------------------------------------------------
Clash's Profile: http://www.excelforum.com/member.php...o&userid=18951
View this thread: http://www.excelforum.com/showthread...hreadid=547010