| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
LIMIT NUMBER OF CHAR IN A COMBINE CELL
HELLO, I HAVE A 2 CELLS THAT I PUT TOGUETHER BY A FORMULA USING "&" SO THIS
IS WHAT IT LOOK LIKE : =B1&D1 OK THAT IS ALL GOOD BUT NOW THE PROBLEM IS THAT B1 HAS 10 CHARACTER AND D1 HAS 3. OK SAMPLE B1= ABCDEFGHIJ D1=123 OK SO THAT MEANS I HAVE IN MY CONBINE CELL A1 =ABCDEFGHIJ123. OK WHAT I NEED, THAT I DONT KNOW HOW TO DO IS FOR A1 TO LOOK LIKE THIS WITH OUT HAVING TO EDIT B1. A1=ABCD123 CAN SOME ONE HELP ME. THANKS |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Limit to the number of items in a cell | Excel Worksheet Functions | |||
| Excel should let me circle a cell or number in the spreadsheet fo. | Excel Discussion (Misc queries) | |||
| How do I format a cell for a custom part number? | Excel Discussion (Misc queries) | |||
| limit number of characters in a cell | Excel Discussion (Misc queries) | |||
| Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
Threaded Mode
