| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
fill or truncate to a certain number of characters in a cell
I need to convert cells containing text to exactly 12 characters either by
truncating or filling with spaces. Does anyone know a formula that will do that? Thanks. Jan Buckley |
|
#2
|
|||
|
|||
|
Hi Jan
with your data in cell A2 =IF(LEN(A2)12,LEFT(A2,12),A2 & REPT(" ",12-LEN(A2))) Cheers JulieD "Jan Buckley" wrote in message ... I need to convert cells containing text to exactly 12 characters either by truncating or filling with spaces. Does anyone know a formula that will do that? Thanks. Jan Buckley |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you count number of characters in a single cell | Excel Worksheet Functions | |||
| limit number of characters in a cell | Excel Discussion (Misc queries) | |||
| how do i filter data by number of characters in excel? | Excel Discussion (Misc queries) | |||
| How do I increment a fill series by a number other than 1? Say I. | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
