Format custom number: C-0000-L

  • Thread starter Thread starter Sonia
  • Start date Start date
S

Sonia

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!
 
Thanks David but the problem is that the second letter is not the same in
every cell, it can bem C-1234-L or C-5678-R, ...
How can i make the formula accept a variable letter in the end?
Thanks!
 
Assuming the number is in cell A1 and the letter is in cell A2 then use this
formula:

="C-"&A1&"-"&A2

Not custom formatting.

Tom
 
Back
Top