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
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
=SUBSTITUTE(A3,"-"," ")
HTH
--
AP
"Clash" <[email protected]> a écrit dans le
message de news: [email protected]...
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks