1) =MID(AO2,FIND("=",AO2)+1, FIND("/",AO2,2)-FIND("=",AO2)-1)
2) =MID(AO2,FIND("=",AO2,6)+1,99)
3) =SUBSTITUTE(MID(AO2,FIND("=",AO2,6)+1,99)," ",".")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Alan Bliss" <Alan wrote in message
...
i am using a mail merge and i need to create special email address to be
sent
via my online fax service...

the email address go as:



I have a fax number and a name in each row in the file i want to insert
the
appropriate fax/email address as above
1) how can i get this column to make this formula by pulling from collumn
AO
(the fax number?
2) how can i get the name in row AZ to convert into the formula?
3) also the names in column AZ are in this format: Alan Bliss, i need them
to be in this format Alan.Bliss.... how can i exchange the space for a
dot?

Please help and Thank you,
I am using all 2003 office products, (by the way)
--Alan