View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
PSL PSL is offline
external usenet poster
 
Posts: 8
Default formatting cells

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.