| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding a character
how do i create a condition on a particular cell if it's characters are less
than 8 it will add a character? e.g. if i put "abcdefg" in my cell, there are only 7 characters in it. the other cell will automatically add a new 1 before the original character so it will become "zabcdefg" which "z" is the character added to make it 8 -- Message posted via http://www.officekb.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel insists on adding character to formula | Excel Worksheet Functions | |||
| adding up a particular character in a row | Excel Discussion (Misc queries) | |||
| Adding a character to a defined name with a formula or macro | Excel Discussion (Misc queries) | |||
| Adding overscore to character in a cell in an Excell spreadsheet | Excel Discussion (Misc queries) | |||
| Adding a character to the beginning and end of txt in a cell | Excel Worksheet Functions | |||
Threaded Mode
