Hi, I need to format a few cells in Excel to look like C-0000-L where "0000"
represents four numbers and "L" represents a letter.
I tried to do it in format - custom with C-0000-@ but it gives me an error
message.
I also tried to do it using the concatenate function but it doesn`t work.
Can anyone please help me?
Thanks!
--
Sonia