Symbology

[Manesh]

Dear Chandoo

I am trying to convert numbers to symbols by referencing each digit to its appropriate symbol.

I have attached a sample data sheet with the requirements.

Ideally, the solution will not contain any Macros or VBA code.

Kindly assist me with this request.

Thank you.

Best regards,

MN

 

[Khalid NGO]

Hi MN,
I had some difficulties while handling duplicates.
Not sure how foolproof is this.

Regards,

 

[NARAYANK991]

Hi ,

See this file.

Narayan

 

[Nebu]

Hi:

Please find an alternate solution with less helper columns.

Thanks