using a formula to replace all

[elseano]

Hi guys
what id like to is type a word in a1 a2 and a3 and it changes a predefined character (such as 1 2 and 3) to those numbers
so for example
in a1 i have DAVID
a2-LUCY
A3- BRETT

in a4 i have-hello 1 make sure you meet up with 2 and 3
in a5 i have - Dear 1 you will be partnered with 2 and 3
and so on
i would like 1 to be replaced with DAVID 2 to be replaced with LUCY and 3 to be replaced with BRETT
(the names inputed will keep changing)

can this be done?
i hope this makes sense
thanks in advance

[protonLeah]

A4: ="hello " & A1& " make sure you meet up with " & A2 & " and " & A3

[elseano]

thanks for the reply but i really don't want to do that for the hundreds of others i have
is there a way where if i type in a1-Brett it changes all 1's in the doc to Brett etc

[elseano]

thanks for the reply but i really don't want to do that for the hundreds of others i have
is there a way where if i type in a1-Brett it changes all 1's in the doc to Brett etc