List of Currency Symbols in Excel

This article illustrates how to access the list of currency symbols in excel. Excel allows you to insert various currency symbols as required. You can easily insert some currency symbols using keyboard shortcuts. Others can be inserted by applying currency formats to numbers or as symbols. But, you may not be able to insert all the currency symbols as just symbols in excel. You can use a simple VBA code to extract currency symbols to make a list of them. Follow the article to learn how to do all of that.


Download Practice Workbook

You can download the practice workbook from the download button below.


Currency Symbols in Excel

You can find the currency symbols in the Symbols group from the Insert tab in excel.

  • First, click on the Symbol icon from the Insert tab to do that.

  • Then, choose the Currency Symbols subset from the dropdown. Next, select the desired currency symbol and click Insert. After that, repeat the procedure for other currency symbols to create a list of them.

list of currency symbols in excel

  • You can also use keyboard shortcuts to insert the currency symbols. But, most of the shortcuts don’t work in excel although they work just fine on other Office applications like Word and Powerpoint. Here is a list of currency symbols in excel with some working keyboard shortcuts.

list of currency symbols in excel

Read More: How to Change Currency Symbol in Excel (2 Handy Ways)


Create a List of Currency Symbols in Excel with VBA

You may not be able to insert all of the currency symbols available in the currency format from the Insert tab. Follow the steps below to extract the currency symbols from currency formatting to create a list of them.

📌 Steps

  • First, enter some numbers in any column. Here you can enter 1 in cell B5. Then drag the Fill Handle icon while holding the CTRL key to create a series.

  • Next, select cell B5 only and then press CTRL+1 to open the Format Cells dialog box. After that, select the Currency format from the Number tab. Then, choose a currency from the dropdown list of currency symbols. Next, click on the OK button.

list of currency symbols in excel

  • After that, you will get the following result.

  • Now apply a different currency format for each cell in the column. After that, you will get the following result.

  • Then, press ALT+F11 to open the VBA window. Next, select Insert >> Module to create a new module.

  • After that, copy the following code.
Function GCS(ByVal Rng As Range) As String
Static XReg As Object
Application.Volatile
If XReg Is Nothing Then
Set XReg = CreateObject("VBScript.RegExp")
End If
With XReg
.Global = True
.Pattern = "[0-9-.,\s]"
GCS = .Replace(Rng.Text, "")
End With
End Function
  • Then, paste the code onto the blank module. Next, save the file as a macro-enabled workbook to avoid losing the code.

  • After that, enter the following custom formula in cell C5. Then drag the Fill Handle icon to the cells below. Then, you will see the following result.

  • Now, copy the list of currency symbols and paste them as values into a different column. Finally, you have the list of currency symbols in excel.

Read More: How to Change Default Currency in Excel (4 Simple Methods)


Things to Remember

  • Some currency symbols are taken from the Greek or Latin alphabet. You may not find them in the Currency Symbols subset while inserting them from the Insert tab. Scroll through the symbols to find the desired currency symbols to insert them.
  • Don’t forget to save the file as a macro-enabled workbook to avoid losing the code. Otherwise, the custom formula won’t work.

Conclusion

Now you know how to create a list of currency symbols in excel. Do you have any further queries or suggestions? Please let us know using the comment section below. You can also visit our ExcelDemy blog to explore more about excel. Stay with us and keep learning.


Related Articles

Md. Shamim Reza

Md. Shamim Reza

Hello there! This is Md. Shamim Reza. Working as an Excel & VBA Content Developer at ExcelDemy. We try to find simple & easy solutions to the problems that Excel users face every day. Our goal is to gather knowledge, find innovative solutions through them and make those solutions available for everybody. Stay with us & keep learning.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo