提示:其它语言是由 Google 机器翻译的。 你可以访问 English 版本。
登录
x
or
x
x
马上登记
x

or

如何在Microsoft Excel中将大写更改为小写?

假设您收到一个包含大写字母的所有文本字符串的Excel报表,如果您可以在Excel中将这些大写字母更改为小写,则会更容易阅读,如下面的屏幕截图所示。 以下技巧可以在Excel中快速将所有大写字母更改为小写。


将文本字符串更改为小写,大写,正确的大小写...

Kutools for Excel's 改变案例 实用程序可以帮助您根据需要将文本字符串更改为大写,小写,正确大小写,句子大小写和切换大小写。 点击下载Kutools for Excel!

doc更改为小写12


方法1:Excel用于将文本更改为小写

Microsoft Excel支持Lower函数将任何类型的文本字符串更改为小写,请执行以下操作:

1。 在相邻的空白单元格D1中,输入或复制公式

=下(A2)

并按下 输入 得到第一个结果的关键。 看截图:

doc更改为小写1

2。 然后,选择单元格D1并将填充柄向下拖动到要应用此公式的单元格,并将所有文本字符串转换为小写字母,请参见屏幕截图:

doc更改为小写2

3。 然后,您应该复制转换后的单元格并将其作为值格式粘贴到原始单元格中。

doc更改为小写3

备注:

要将文本字符串转换为大写,请应用以下公式:

=UPPER(A2)

doc更改为小写4

要将文本字符串转换为正确的大小写,这意味着要将每个单词的首字母大写,请应用以下公式:

=PROPER(A2)

doc更改为小写5


办公室标签图片

裁员赛季即将到来,仍然缓慢运作?
-- Office Tab 提高您的步伐,节省50%的工作时间!

  • 惊人! 多个文档的操作比单个文档更加轻松和方便;
  • 与其他Web浏览器相比,Office Tab的界面更加强大和美观;
  • 减少成千上万的繁琐鼠标点击,告别颈椎病和老鼠手;
  • 被90,000精英和300 +知名公司选中!
全功能,免费试用30天 了解更多 现在就下载!

方法2:Flash Fill功能将文本更改为小写

在Excel 2013及更高版本中,有一个方便的实用程序 - Flash填充使用此功能,您也可以快速解决此任务。

1。 在要更改大小写的数据旁边插入一个空白列,然后输入要使用的第一个文本字符串。 例如,我将在单元格B2中键入带小写的文本字符串,请参见屏幕截图:

doc更改为小写6

2。 键入正确的格式化文本字符串然后选择它,然后单击 主页 > > 填写Flash,此列中的其余单元格将填充小写文本字符串,请参见屏幕截图:

doc更改为小写7

备注:

1。 要获取所有大写文本,请在第一个单元格中键入大写文本,然后应用 Flash填充 功能;

2。 要获取所有正确的案例文本,请在第一个单元格中键入首字母大写的文本字符串,然后应用 Flash填充 功能;


方法3:将文本更改为小写的VBA代码

以下VBA代码还可以帮助您根据需要更改文本字符串大小写,转换后的结果将直接替换为原始值。

1。 按住 Alt + F11键 键打开 Microsoft Visual Basic for Applications 窗口。

2。 点击 插页 > 模块,并将以下代码粘贴到模块窗口中。

VBA代码:将文本字符串更改为小写:

Sub LCase()
Dim Rng As Range
Dim WorkRng As Range
On Error Resume Next
xTitleId = "KutoolsforExcel"
Set WorkRng = Application.Selection
Set WorkRng = Application.InputBox("Range", xTitleId, WorkRng.Address, Type:=8)
For Each Rng In WorkRng
    Rng.Value = VBA.LCase(Rng.Value)
Next
End Sub

3。 然后,按 F5 键运行此代码,在弹出的提示框中,选择要转换的单元格范围,请参见截图:

doc更改为小写8

4。 然后,点击 OK 按钮,所选单元格中的所有文本字符串都已转换为小写,请参见屏幕截图:

doc更改为小写9

备注:

将文本字符串更改为大写,请将此VBA代码复制并粘贴到模块中:

Sub UCase()
Dim Rng As Range
Dim WorkRng As Range
On Error Resume Next
xTitleId = "KutoolsforExcel"
Set WorkRng = Application.Selection
Set WorkRng = Application.InputBox("Range", xTitleId, WorkRng.Address, Type:=8)
For Each Rng In WorkRng
    Rng.Value = VBA.UCase(Rng.Value)
Next
End Sub

将每个单词的首字母大写,请将此VBA代码复制并粘贴到模块中:

Sub ProperCase()
Dim Rng As Range
Dim WorkRng As Range
On Error Resume Next
xTitleId = "KutoolsforExcel"
Set WorkRng = Application.Selection
Set WorkRng = Application.InputBox("Range", xTitleId, WorkRng.Address, Type:=8)
For Each Rng In WorkRng
    Rng.Value = Application.WorksheetFunction.Proper(Rng.Value)
Next
End Sub

方法4:用于Excel的Kutools将文本更改为小写

Kutools for Excel

300高级工具,解决1500工作场景

解决80%Excel难题,提高80%的生产力

帮助您获得促销,
增加薪水!

由110,000精英,300 +知名公司选择

如果你有 Kutools for Excel 安装好了 改变案例 工具可以帮助您直接将所有文本字符串更改为小写,大写,正确大小写,句子大小写和切换单元格。

安装后 Kutools for Excel,请这样做:

1。 选择要更改大小写的单元格,然后单击“确定” Kutools > 文本 > 改变案例,看截图:

doc更改为小写10 1

2。 在 改变案例 对话框中选择 小写 选项,然后单击 OK or 申请 按钮,所有文本字符串都已转换为您想要的小写,请参见屏幕截图:

doc更改为小写11

提示建议: 这个 改变案例 实用程序还可以帮助您根据需要将文本字符串更改为大写,正确的大小写,句子大小写和切换大小写。


周末忙碌的工作,使用 Kutools for Excel,
给你一个轻松愉快的周末!

在周末,孩子们大声疾呼要出去玩,但是周围有太多工作无法陪伴家人。 太阳,沙滩和大海那么远? Kutools for Excel 帮助您 解决80%Excel难题,节省80%的工作时间。

pic海滩
  • 获得晋升并增加工资并不遥远;
  • 包含300高级功能,解决1500应用场景,一些功能甚至可以节省99%的工作时间;
  • 成为3分钟的Excel专家,并获得同事或朋友的认可;
  • 不再需要从谷歌搜索解决方案,告别痛苦的公式和VBA代码;
  • 只需点击几下即可完成所有重复操作,释放疲惫的双手;
  • 只有$ 39,但值得其他人的$ 4000 Excel教程;
  • 被110,000精英和300 +知名公司选中;
  • 30天免费试用,并在60天内全额退款,没有任何理由;
  • 改变你的工作方式,然后改变你的生活方式!
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    toolnx · 2 years ago
    Simple online tool for convert case
    Convert Case
  • To post as a guest, your comment is unpublished.
    Prabhukalyan Dhal · 2 years ago
    Is there any simple method without using any formula within the same excel sheet ?
  • To post as a guest, your comment is unpublished.
    Raghavendra · 3 years ago
    My friends Upper case and Lower case formula is =UPPER(COLOM &ROW ) ENTER
  • To post as a guest, your comment is unpublished.
    sandeep verma · 3 years ago
    how to ms excel in current cell & all selected cell upper case & lower case formula use in this work sheet . because used short key of sued key board .

    than show result.
  • To post as a guest, your comment is unpublished.
    sandeep verma · 3 years ago
    advance excel note book .

    warms regard.

    sandeep verma

    Thank's
  • To post as a guest, your comment is unpublished.
    fatima · 3 years ago
    Thank you so much i learnt what i wanted to know in excel
  • To post as a guest, your comment is unpublished.
    Jessica Vu · 4 years ago
    Thanks very much. It is so useful & easy to understanding. :-)
  • To post as a guest, your comment is unpublished.
    sharad · 4 years ago
    thanks,
    your suggestion very helpful
  • To post as a guest, your comment is unpublished.
    Sasikumar · 4 years ago
    Dear sir,

    when i strat to enter in the excel column i expected only uppercase using some formula. Please answer me
  • To post as a guest, your comment is unpublished.
    Sagar Jadhav · 4 years ago
    Thank you Very much it's very easy use ....... :-)
  • To post as a guest, your comment is unpublished.
    Ola · 4 years ago
    Can anybody help please? I am trying to perform vlookup and is coming as #N/A, i can confirm that what i am looking for actually exist in the column
  • To post as a guest, your comment is unpublished.
    Rsilva · 4 years ago
    very useful and easy

    thank you
  • To post as a guest, your comment is unpublished.
    ATULCHANDRA · 4 years ago
    VERY USEFUL ANSWER WITH MULTIPLE OPTION.
  • To post as a guest, your comment is unpublished.
    PHILEMON · 4 years ago
    THAT FOR MAKING ME UNDERSTAND
  • To post as a guest, your comment is unpublished.
    KIRAN · 4 years ago
    IT WAS USEFULTHANK YOU :) [/b]
  • To post as a guest, your comment is unpublished.
    parvathi arungopal · 4 years ago
    thanks for your good answer
  • To post as a guest, your comment is unpublished.
    mckillio · 4 years ago
    This didn't do anything, my cell (F2) just says =LOWER(E2). Does this have to be columns A and B?
  • To post as a guest, your comment is unpublished.
    Diljith · 4 years ago
    This looks heavily complex process. I am saying this for those who love shortcuts and less brain burns. thing is simple, copy the cell which you want to change the case, paste in a new blank word document, change its case and copy and paste it back into excel,BINGO !!!!...you're done
  • To post as a guest, your comment is unpublished.
    Nandu · 5 years ago
    Is there a short key for this ??
  • To post as a guest, your comment is unpublished.
    naim · 5 years ago
    how to set uppercase text with number.
    for example : jun-14
    • To post as a guest, your comment is unpublished.
      Rohit Karle · 5 years ago
      U just need to have a single quote(') for the numbers which are date.
      Eg. 'jun-14
      Use Formula =UPPER(CELL NUMBER).
      If it is other than date and all, You don't need to have single quote.
  • To post as a guest, your comment is unpublished.
    Jeanne B. · 5 years ago
    There is an easier way. In Excel, copy the entire column. Launch Word. Make new document. Paste. Use Word's case change button to change case. Select all. Copy. Return to Excel. Paste.


    Or... MAYBE EXCEL COULD INSTALL A CASE CHANGE BUTTON?
  • To post as a guest, your comment is unpublished.
    Basha · 5 years ago
    Very Helpful.

    Thank You
  • To post as a guest, your comment is unpublished.
    Madhuri · 5 years ago
    how to small letters change to capital letter in key board excel 2007
  • To post as a guest, your comment is unpublished.
    John Smith · 5 years ago
    Thanks a lot. you have done a great job. :-) :-) :-) this is an great article
  • To post as a guest, your comment is unpublished.
    Nas · 5 years ago
    What is the next step after the below comment?
    Note: This method can only change all the uppercase letters into lowercase in a new range, so you may have to take a further step to replace the uppercase letters with the lowercase letters.


    --------------------------------------------------------------------------------
    • To post as a guest, your comment is unpublished.
      tester · 5 years ago
      [quote name="Nas"]What is the next step after the below comment?
      Note: This method can only change all the uppercase letters into lowercase in a new range, so you may have to take a further step to replace the uppercase letters with the lowercase letters.


      --------------------------------------------------------------------------------[/quote]
      copy ---> paste special ----> values
  • To post as a guest, your comment is unpublished.
    asad · 5 years ago
    Thanks. Great article. MS should use this on their documentation instead
  • To post as a guest, your comment is unpublished.
    Lisa B · 5 years ago
    Or, use function =Proper(cell) to have capitals for first letter of names, cities, etc...
    • To post as a guest, your comment is unpublished.
      Bryan · 5 years ago
      This is an even Faster way to do it using VBA instead of excel functions.

      Sub LOWER_CASE()
      Addr = Intersect(ActiveSheet.UsedRange, Selection).Address
      Range(Addr) = Evaluate("IF(LEN(" & Addr & "),LOWER(" & Addr & "),"""")")
      End Sub

      Go to developer tab>macros>(type a name for the new macro)>create. and paste above code, now every time you run the macro it will change the case of the current selection to lowercase.

      Note. if you want to use it for UPPER or Proper case, you only have to replace all the "LOWER" ' s in the code with PROPER or UPPER depending of what you need.
      • To post as a guest, your comment is unpublished.
        anna · 3 years ago
        sometimes using VBA is more confusing than excel function, especially for Excel amateur like me lol