Thread: how to format cells having text and numeric
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PSL PSL is offline
external usenet poster
  
Posts: 8
Default how to format cells having text and numeric
Hi,
Please help me formating cells.

Example:

DM17043X10 - this is the text having in a cell

I need to format the above text as:

DM-1704- -3X10

spaces given between 4- & -3
Please help me on this.

Thank You,
PSL.
Reply With QuoteReply With Quote