Excel中的VBA [英] VBA in Excel
问题描述
是否可以"排序"一个单元格内的一系列单位数字?
特别是,我有一个Excel电子表格,其中有一列包含代表每个客户状态的单个数字(1到8),每行一个。
例如,"1"和"1"。表示订单被接受,"2"表示订单被接受。表示正在处理,"3"表示正在处理表示已打印文书工作,但不一定按此顺序。因此,我们可能有一个包含"1 3 5 2 6 4 7"的单元格,其中I
想要分类为"1 2 3 4 5 6 7"。为了便于阅读。
我所能想到的是在插入时,检查每个现有数字并相应地放置新值。但是,移动和放置数字会引起一些麻烦。
我非常感谢一些帮助。
提前致谢。 Peter
Hello Peter,
这是Visual Studio中VB的论坛Net
您的问题是关于Excel或Visual Basic for Applications,
这是其他Microsoft论坛。
https://social.msdn.microsoft .com /论坛/ en-us / home?forum = isvvba
https://social.msdn.microsoft.com/Forums/office/en-US/home?forum=exceldev
自己做出选择
Is it possible to "sort" a series of single-digit numbers within one cell?
In particular, I have an Excel Spreadsheet which has one column containing single digit numbers (1 to 8) representing the status of each customer, one per row.
For instance, "1" means the order is accepted, "2" means it is being processed, "3" means paperwork has been printed, but not necessarily in that order. So, we might have a cell containing "1 3 5 2 6 4 7", which I would like to sort into "1 2 3 4 5 6 7" for ease of reading.
All I have been able to think of is at the time of insertion, examine each existing digit and place the new value accordingly. But, moving and placing the digits is causing somewhat of a headache.
I would very much appreciate some help.
Thanks in advance. Peter
Hello Peter,
This is the forum for VB in Visual Studio Net
Your question is about Excel or Visual Basic for Applications ,
That are other Microsoft forums.
https://social.msdn.microsoft.com/Forums/en-us/home?forum=isvvba
https://social.msdn.microsoft.com/Forums/office/en-US/home?forum=exceldev
Make your own choise
这篇关于Excel中的VBA的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!