Prev: How do I stop Excel from automatically resizing my row height?
Next: Clearing fields when differnt function selected
From: Sonia on 9 Apr 2010 11:42
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
From: "David Biddulph" groups [at] on 9 Apr 2010 11:51
Custom format "C-"0000"-L"
--
David Biddulph


"Sonia" <Sonia(a)discussions.microsoft.com> wrote in message
news:8EAB02FD-1AA5-4E80-880A-7C9A33A8FE01(a)microsoft.com...
> 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


From: Sonia on 9 Apr 2010 12:44
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!
--
Sonia


"David Biddulph" wrote:

> Custom format "C-"0000"-L"
> --
> David Biddulph
>
>
> "Sonia" <Sonia(a)discussions.microsoft.com> wrote in message
> news:8EAB02FD-1AA5-4E80-880A-7C9A33A8FE01(a)microsoft.com...
> > 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
>
>
> .
>
From: tompl on 9 Apr 2010 12:56
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
 | 
Pages: 1
Prev: How do I stop Excel from automatically resizing my row height?
Next: Clearing fields when differnt function selected