Parsing out data

[jpd101721]

Hello.

I recently started a position in finance where the software that is used by employer doesn't produce the most user friendly financial statement. I am working on trying link excel to the database directly so I can refresh the numbers as often as I like, but right now I am trying to create a formula where I can take a couple key fields and translate them into a user friendly document. My first task is to take the general ledger description (a single excel field) and translate it in an easily readable description. Below is the first example:

GF-G-GE-DW-GP-E-Rate

<colgroup><col></colgroup><tbody>
</tbody>

I would like to translate this into the following:

Cell 1 Cell2 Cell3 Cell4 Cell5 Cell6
General fund G General Education District Wide General Purpose E-Rate

I think I need to create left, mid and right statments, but I am not sure of the best approach. Any advice is greatly appreciated!

 

[discoCommando]

In excel u have really cool option like Text To Columns command.

How to parse data using the Text To Columns command in Excel

there u have good guide but except for selecting comma as delimiter, u have to use "-" as delimiter.

It helps u with separating GF-G... to the columns. And then u can just do some ifs like if(Cell1="GF";"General fund"; other if....)

I hope it will help a little.