Thread: How to create a prefix containing text and zero?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier
 
Posts: n/a
Default How to create a prefix containing text and zero?
Hi Gene

A bit sparse on requirements but here's a guess
With part number in A1
="Part Number 0"&A1

Regards

Roger Govier


GeneWan wrote:
Reply With QuoteReply With Quote