im entering mobile phone nos and i want excel to show the person's name.
something like conditional formatting
2006-06-12
21:50:31
·
3 answers
·
asked by
Anonymous
in
Computers & Internet
➔ Software
i hav 1 sheet starting from a1. A contains names. b theri cell nos.
it like
a b
1 abc 123
2 zyw 235...
now supose at other sheets i hav nos at d
ie
a b c d e
1 123
2 235
4
n so on.
now i want excel to display this as
a b c d e
1 abc
2 zyw
4
pl help. thanx.
2006-06-12
23:00:39 ·
update #1
___a_____b
1_abc___123
2_xyz___345
and
__A___b____c____d
1______________123
2______________345
3
i want
__A___b____c____d
1______________abc
2______________xyz
3
2006-06-12
23:02:58 ·
update #2