How do I convert a concatenated value into a know value

  • Thread starter Thread starter collingrey
  • Start date Start date
C

collingrey

Hi all

I am trying to get the results of a multiple input table, which get
concatenated, read out as usable values

eg. If the concatenated values are for example *llbbt* , I need this t
be read as Simon, or *lbttd* must result in Fred etc...

I will attact the spreadsheet.

Thanks
Colli

Attachment filename: book3.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=54116
 
You are probably better off by describing your problem, most regulars won't
open files..
 
OK

I need to get the results of a concatenated field, to be expressed as
known or defined value.

If I concatenate various inputs for examples L, R, T, B the results ca
be LR, LT, LB, RT, RB, TB...

Now when these resultas are displayed I want, say LR to be shown a
Tommy, LT as Jeff, LB as Greg... etc.

I was thinking og usinf an IF THEN type statement, but cannot seem t
get it right.

Colli
 
Back
Top