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.
- 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.
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.
- 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.
- 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.
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.
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.
- Convert Currency to Words in Excel (with Easy Steps)
- Currency with 2 Decimal Places in Excel (with Quick Steps)
- Difference Between Accounting and Currency Format in Excel
- Excel VBA: Format Currency to Two Decimal Places (3 Methods)
- Remove Currency Symbol in Excel (6 Ways)
- How to Concatenate and Keep Currency Format in Excel (3 Methods)