Urgent help needed? How do I limit the number of characters i
THANK YOU THIS WORKED!!!
"FSt1" wrote:
hi
you cannot use formating to shorten the number of characters in a cell.
formating just changes the way the data looks, not the data inself.
but if you DO need to reduce the number of characters a column of cells then
look at the text to columns function. this splits data in a column into
different columns.
on the menu bar...Data text to columns...
you can probable use the fixed width function and snap a line at the number
of characters you need.
note: Add a column to the right of the column you want to parce for excel
will delete data to the right at parce.
regards
FSt11
"greatdeals_007" wrote:
I am using a program that limits the number of characters in a product model
number to 12 characters. my file currently contains may line items with
model numbers that exceed this limit.
how do I format the column to shorten the number of characters? I have
tried using the data validation but it did nothing for me. can you help?
|