BASIC Input Mask

[dragonmouse]

Haven't needed to do this in a long time. INPUT MASK (I thought it was formatting)

I have several computers the name is COMP-BLD222****

The **** is the last four of the serial number. the COMP-BLD222 will be the same for all.

QUESTIONS;
1. how do I create a "mask" to just add the last 4?
2. Could I somehow combine the MASK with the last for of the serial column so it would be really easy?

 

[johnny51981]

Answers:
1. Highlight the cells/columns that you are wanting this to be performed and then go to the Format Cells. Select Custom. In the empty box under where it says Type:, put "COMP-BLD222"#### (including the quotes and the 4 pound/hashtag signs.
2. Now that answer 1 has been put into place, you just need to enter those last 4 characters. Excel will add in the COMP-BLD222 to each one.

 

[dragonmouse]

Johnny51981 that worked.

However on the bright side I found an answer that worked even better than an input mask:

In a "hidden" column (R3) I used this formula =RIGHT([@[Serial Nbr]],4)

Then in the column I wanted the name in I used =CONCATENATE("COMP-BLDG222",R3)

By whatever miracles that be...it worked better than masking anyway because just copying it down it filled everything in automatically rather than typing it in.