thank you so much that's brilliant!
On Wednesday, 14 May 2014 04:36:45 UTC+1, Vicky wrote:
>
> Hello Wendy,
>
> See attached UDF to separate alpha numeric characters with dash (-).
>
> Regards,
>
>
> On Wed, May 14, 2014 at 1:18 AM, Wendy Beckett
>
> > wrote:
>
>> Don't know if anyone can help
Hello Wendy,
See attached UDF to separate alpha numeric characters with dash (-).
Regards,
On Wed, May 14, 2014 at 1:18 AM, Wendy Beckett wrote:
> Don't know if anyone can help me but I am trying to format cell contents
> that are a combination of numbers and text. I would like the cell conten
Don't know if anyone can help me but I am trying to format cell contents
that are a combination of numbers and text. I would like the cell content
Jan1324 to display as Jan-1324 is there any way I can use the custom format
to do this? Any help appreciated its been driving me mad all day!! Thank
