yogi_Pull Abbreviations From SpreadsheetA And Present Them As Terms Based On A Lookup Table

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

user1294 said:
How to replace multiple strings in imported data range??
Hello!
I have 2 spreadsheets: one with raw data table and the other empty.
raw data has abbreviations (Abs, AVRG, TTL etc.) which I need to be full readable words (absolute, average, total etc.) in the second (empty) spreadsheet.
I'm using importrange function
maybe I should use script to create custom function??
please help, I'm a newbie))
-------------------------------------
following is a solution to the problem