Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format a Concatenated cell
I want to concatenate three letters and three numbers i.e. BLA001 But I can't seem to format the cell to produce this. does anyone have any ideas? or is there an easier way? The next number would be BLA002 and so on. -- Timbo ------------------------------------------------------------------------ Timbo's Profile: http://www.thecodecage.com/forumz/member.php?userid=24 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=58780 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format a Concatenated cell
Where is the BLA coming from? Will that change? If not, you can use custom cell formatting to create that reference. Put the number 1 in the cell, then click CTRL-1 to open the Format Cell box. Select Number: Custom and in the TYPE: box put this: BLA000 Those are three zeros at the end. The cell will now display as BLA001. If you add 1 to it, it will become BLA002. In fact if that were cell A1, in A2 you could put =A1+1 ....and it would still display as BLA002...as long as all those cells are using that same custom format. -- JBeaucaire ------------------------------------------------------------------------ JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=58780 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format a Concatenated cell
Assuming BLA and 1 are in separate cells, then you want:
=a1&text(a2,"000") Regards, Fred. "Timbo" wrote in message ... I want to concatenate three letters and three numbers i.e. BLA001 But I can't seem to format the cell to produce this. does anyone have any ideas? or is there an easier way? The next number would be BLA002 and so on. -- Timbo ------------------------------------------------------------------------ Timbo's Profile: http://www.thecodecage.com/forumz/member.php?userid=24 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=58780 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format part of text in concatenated field | Excel Worksheet Functions | |||
Formatting a value in a concatenated cell | Excel Discussion (Misc queries) | |||
Number Formatting in a concatenated cell | Excel Worksheet Functions | |||
sorting a concatenated cell | Excel Discussion (Misc queries) | |||
format a number concatenated with text | Excel Discussion (Misc queries) |