Home » Forums » Open Source Learning Center » Question and Answer

Formula to convert first digit of a number to Text

Submitted by David123 on 9 May, 2012 - 00:48

Hi I need help to convert the first digit of a number code to a letter.

Example:

Need to convert 342436 to A42436; and 447623 to B447623 and vice versa,

Can someone help me with a formula please.

Thanks
David

‹ Reading large data into Excel using arrays or otherwise Conundrum... ›
»
Vishesh's picture

Provide some pattern or logic

Submitted by Vishesh on 18 May, 2012 - 17:25.

Provide some pattern or logic behind it so that some formula or code can be applied

»