software

I have the text A012 This is a Test, can i use a custom format to display in
a cell just A012, the format of the text will always be letter followed by 3
numbers but i don't want any more letters.

I am sure this is simple but my heads not working today

Hi Jack

Formatgt;Cellsgt;Numbergt;Custom and A000 in the white pane, or A 000 if you
would prefer to have a space between the letter and numbers.
Enter 12 in cell it will display as A012

--
Regards

Roger Govierquot;Jackquot; gt; wrote in message
...
gt;I have the text A012 This is a Test, can i use a custom format to
gt;display in
gt; a cell just A012, the format of the text will always be letter
gt; followed by 3
gt; numbers but i don't want any more letters.
gt;
gt; I am sure this is simple but my heads not working today
Assuming that you do not want to remove the trailing text, only not display it:

1. select the cell
2. in the formula bar, select the part of the text you want to hide
3. pull-down Format gt; Cells... gt; Font and make the color of the font the
same as the color of the background

The only thing visible in the cell will be the text you have not
re-formatted in this way.If you want to get rid of the trailing text, use something like:
=LEFT(A1,4)
--
Gary''s Studentquot;Jackquot; wrote:

gt; I have the text A012 This is a Test, can i use a custom format to display in
gt; a cell just A012, the format of the text will always be letter followed by 3
gt; numbers but i don't want any more letters.
gt;
gt; I am sure this is simple but my heads not working today

Forget that.
Totally misread your post.

--
Regards

Roger Govierquot;Roger Govierquot; gt; wrote in message
...
gt; Hi Jack
gt;
gt; Formatgt;Cellsgt;Numbergt;Custom and A000 in the white pane, or A 000 if
gt; you would prefer to have a space between the letter and numbers.
gt; Enter 12 in cell it will display as A012
gt;
gt; --
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt; quot;Jackquot; gt; wrote in message
gt; ...
gt;gt;I have the text A012 This is a Test, can i use a custom format to
gt;gt;display in
gt;gt; a cell just A012, the format of the text will always be letter
gt;gt; followed by 3
gt;gt; numbers but i don't want any more letters.
gt;gt;
gt;gt; I am sure this is simple but my heads not working today
gt;
gt;
This has done it thank you.

quot;Gary''s Studentquot; wrote:

gt; Assuming that you do not want to remove the trailing text, only not display it:
gt;
gt; 1. select the cell
gt; 2. in the formula bar, select the part of the text you want to hide
gt; 3. pull-down Format gt; Cells... gt; Font and make the color of the font the
gt; same as the color of the background
gt;
gt; The only thing visible in the cell will be the text you have not
gt; re-formatted in this way.
gt;
gt;
gt; If you want to get rid of the trailing text, use something like:
gt; =LEFT(A1,4)
gt; --
gt; Gary''s Student
gt;
gt;
gt; quot;Jackquot; wrote:
gt;
gt; gt; I have the text A012 This is a Test, can i use a custom format to display in
gt; gt; a cell just A012, the format of the text will always be letter followed by 3
gt; gt; numbers but i don't want any more letters.
gt; gt;
gt; gt; I am sure this is simple but my heads not working today