Do you only have one entry in a cell that needs to be abbreviated, or
might you have several words/phrases in a cell that need to be
changed? If the latter, what is the maximum number of words that would
need to be changed? Presumably, if you have any words that are not in
your dictionary then these would remain unchanged?

Depending on your answers to the above, you could think about using
the REPLACE function or the SUBSTITUTE function or even VLOOKUP in a
formula which can be copied down a helper column.

Hope this helps.

Pete

On Aug 15, 5:39*pm, shangud wrote:
I am a data modeller and I need to abbreviate business names into column
names. I have multiple words in a cell that I have to abbreviate by looking
against a dictionary

For example I have Invoice Amount and it needs to be abbreviated to inv_amt.
I have a worksheet containing 2 columns one with the abbreviation and other
with the complete word.

How do I write a macro to convert a long list of business names in to
abbreviated column names? Any advice is appreciated

Regards