Hi Roger,

Thanks for the suggestion, I should have been more detailed: I'm trying to
achieve creating the prefix so that it will appear along with the number that
I key in.

Eg. after typing "12" the cell should show SN0012, where "SN00" is my prefix.

Appreciated.. :)

"Roger Govier" wrote:

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: