formatting cells

P

PSL

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.
 
D

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.
Click to expand...
 
A

Amit Kumar Baidyaka

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.
 
Top