custom number format code using letters and numbers
Hi,
Let's say in column A you have your letters and in column B your numbers
then in column C enter
=A1&"-"&B1
copy formula down
if this helps please click yes, thanks
"Foo Foo Daddy" wrote:
How can I format my cell to display letters, a dash, then #s? For example:
ABC-12345678, or 2DE-12347562, or FG3-46518673?
|