Convert Time to Text in Excel: 3 Effective Methods

Method 1 – Use TEXT Function


  • We add a new column on the right side.

  • Go to Cell C5.
  • Put the following formula based on the TEXT function.


Apply TEXT function to convert time to text

  • Press the Enter button.

  • Drag the Fill Handle icon downwards.

Drag the fill handle to fill the formulaTime is converted to text without changing the presentation.

Method 2 – Use a Suitable Text Editor


  • Go to the Desktop window.
  • Press the right button of the mouse.
  • Choose the Text Document option from the New section on the menu.

  • A new notepad window appears.

We will paste data into this notebook.

  • Go to the Excel Sheet.
  • Choose the Range B5:B9. Press the Ctrl + C to copy data.

Copy data to convert to text in Excel

  • Paste the data into the notepad by pressing Ctrl+V.

  • Change the format of the cells where to put the data.
  • Choose the Range C5:C9.
  • Press the down arrow from the Number format.
  • Choose the Text option from the list.

Change the format of cell to convert in Excel

  • Copy data from the notepad.

  • Paste data on Cell C5.

We can see time is converted to text without changing data representation.

Method 3 – Convert Time to Text Using Text to Columns Tool


  • We copy the data from the Time column into the next column.

  • Choose Range C5:C9.
  • Select the Data tab.
  • Choose Text to Columns from the Data Tools group.

Apply text to columns feature to convert in text

  • The Convert Text to Columns Wizard window appears.
  • Choose the Delimited option.
  • Press the Next button.

  • 2nd window of the Convert Text to Columns Wizard feature.
  • Unmark all the options from the Delimiters, press the Next button.

  • The last window appears finally.
  • Choose the Text option.
  • Click the Finish button.

Choose data type in Text to columns in Excel

  • Look at the sheet.

Converted data are in text format.

Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.

Related Articles

<< Go Back to Time Conversion | Date-Time in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Alok Paul
Alok Paul

Alok Paul has completed his B.Sc. in Electronics and Telecommunication Engineering from East West University. He has been working on the ExcelDemy project for more than 2 years. He has written 220+ articles and replied to numerous comments. He is experienced in Microsoft Office, especially in Excel. He also led some teams on Excel and VBA content development. He has a keen interest in Advanced Excel, Data analysis, Excel Pivot Table, Charts, and Dashboard. He loves to research... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF