Divide entire column in excel (accounting) in 2 separate column (symbol + value)?

Question

how to divide excel field with format accounting omitted, for example: $ 220 € 140 $ 220 € 140 $ 220 € 140 $ 220 € 140 etc...etc... So, from one field-column A, to get 2 column A (for accounting symbol) and B (for value)?

Answer 1

1. Select the column that has the field
2. Click "Data" in the ribbon and select "Text to Columns"
3. In this example, choose "Fixed width"
4. In the Data preview box, move the arrow and position it just to the right of the money symbol (inbetween the money symbol and the number). Click "Next"
5. Select "Destination" if you want the information to be put in another column
6. Click "Finish"

Hope this helps! Let me know if you need more assistance!

-TutorB

Answer 2

HI!

There are several ways to accomplish this. In my opinion, the easiest method would be the 'Text to Columns' function. It is located under the Data tab.

To use this feature:

1. Before you begin plan out where your final data will go. You may need to insert blank columns to the right of your data.
2. If you have columns of data directly to the right of your data, 'Text to Columns' will ask "There's already data here. Do you want to replace it?".
3. Clicking 'Ok' will delete any data you have that is in the way and replace it with your new data.
4. Clicking cancel will not simply end 'Text to Columns' without separating your data.
5. You can count the original column when deciding how many columns you need. For example, if your original data is in column A and it is being separated into three columns, then the resulting data will be in columns A, B, and C.
6. Select the cells that you would like to separate and click Text to Columns.
7. Choose either Delimited or Fixed Width
8. Delimited will let you divide your data where ever specified characters exist. For example, if you want to separate "Your best day" where ever there is a space. The result would be three columns "Your" "best" "day". Note: Your specified characters are eliminated during the process.
9. Fixed Width will let you divide your data after a set number of characters. For example, if you want to separate "Your best day" after 4 and 9 characters. The result would be "Your" " best" " day". Note: Fixed will not remove the spaces like Delimited.
10. It looks like your data has a space between the symbol and the value, so I would choose Delimited. However, if there is not a space, I would choose Fixed Width.
11. To use Delimited, select you Delimiters (Specified Characters) and click Next. The prompt will show you a preview of how the data will be divided.
12. To use Fixed Width, click in the 'Data Preview' section where you want a separation and click Next. You can add multiple separations if you like. If you clicked in the wrong spot, you can drag the arrow to the correct location. If you clicked too many times (have too many separations), you can drag an arrow to the far left to remove it.
13. Step 3 lets you choose the format for your final results. The column highlighted in black, is the column that is being referenced. You can click on each column to specify the format for that column. I almost always leave it as "General" format, but in this case you may need to leave the symbols as "Text".
14. This step also gives you the option to "Do not import column". For example, if you were separating "March 20th, 2019" and you only want to keep "March", then you would not import the right hand columns.
15. Once your data is previewed the way you like, click Finish to have it applied to your data.

I hope this is helpful!