formatting cells

[Guest]

Hi,

I need help for formatting cells in the below format:

Example:

DM04084X6 - This is the text having in a cell and I want to format this to
the below format

DM-0408- -4X6

There is a space between 8- and -4
Please help on this.

Thank You,
PSL.

 

[Dave Peterson]

See your other post.

Hi,

I need help for formatting cells in the below format:

Example:

DM04084X6 - This is the text having in a cell and I want to format this to
the below format

DM-0408- -4X6

There is a space between 8- and -4
Please help on this.

Thank You,
PSL.

 

[Guest]

Hi
This can be done by using left, mid, and right formulae....
First take first 2 left digit, add hyphen, again take middle 4 digits using
MID formulae, again add hyphen finally take 3 right digits.

thanks
amit.