B
Big Cat
Hi All:
I was wondering if one of you Excel guru's out there could coach me
through this challenge I have. I run an extract report from our
business system into Excel and I need to have a particular column of
data changed as follows:
From: 06001 To: 06-001
Is there a formula of some sort that I could write to handle inserting
the hyphen "-" in between the 2nd and 3rd character of my data column
to accomplish this?
Please help.
Thanks,
Big Cat
I was wondering if one of you Excel guru's out there could coach me
through this challenge I have. I run an extract report from our
business system into Excel and I need to have a particular column of
data changed as follows:
From: 06001 To: 06-001
Is there a formula of some sort that I could write to handle inserting
the hyphen "-" in between the 2nd and 3rd character of my data column
to accomplish this?
Please help.
Thanks,
Big Cat