Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I format a specific column of cells to have a limit aount of characters?
Can you give an example of how you want it to look?
"limshady411" wrote in message ... Hello, I'm trying to format a column of cells to a specific format (Right Click -- Format Cells -- Custom). I'm just a little confused about the syntax. Is there a way I can make a cell like so: Can only be 6 characters, and if the data is out less than 6, it should append a space for each character to get to 6. Thanks! -- limshady411 ------------------------------------------------------------------------ limshady411's Profile: http://www.excelforum.com/member.php...o&userid=28711 View this thread: http://www.excelforum.com/showthread...hreadid=493993 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I format a specific column of cells to have a limit aount of characters?
You may want to check the system date on your computer. Your question was
posted in the future. "limshady411" wrote in message ... Hello, I'm trying to format a column of cells to a specific format (Right Click -- Format Cells -- Custom). I'm just a little confused about the syntax. Is there a way I can make a cell like so: Can only be 6 characters, and if the data is out less than 6, it should append a space for each character to get to 6. Thanks! -- limshady411 ------------------------------------------------------------------------ limshady411's Profile: http://www.excelforum.com/member.php...o&userid=28711 View this thread: http://www.excelforum.com/showthread...hreadid=493993 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I format a specific column of cells to have a limit aount of characters?
Hello, I'm trying to format a column of cells to a specific format (Right Click -- Format Cells -- Custom). I'm just a little confused about the syntax. Is there a way I can make a cell like so: Can only be 6 characters, and if the data is out less than 6, it should append a space for each character to get to 6. Thanks! -- limshady411 ------------------------------------------------------------------------ limshady411's Profile: http://www.excelforum.com/member.php...o&userid=28711 View this thread: http://www.excelforum.com/showthread...hreadid=493993 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I format a specific column of cells to have a limit aount of characters?
Thanks for responding Barb. Column A (6 characters max, place space as a filler if you don't reach 6) abc(space1)(space2)(space3) My goal is to format this worksheet so that when I save as a txt file, each row in the worksheet will be "one string" of data formated a specific way based on the format of the columns of each cell. I hope this makes sense :) Thanks! -- limshady411 ------------------------------------------------------------------------ limshady411's Profile: http://www.excelforum.com/member.php...o&userid=28711 View this thread: http://www.excelforum.com/showthread...hreadid=493993 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find & Replace - Limit search to a specific column | Excel Worksheet Functions | |||
extracting characters at a specified limit to seperate cells | Excel Discussion (Misc queries) | |||
Is there a limit number of characters for cells in pivot Tables? | Excel Discussion (Misc queries) | |||
how to format only specific characters or numbers within each cellwithin a range of cells | Excel Discussion (Misc queries) | |||
Format single column cells to be 6 characters long | Excel Worksheet Functions |