Try it this way using ampersand symbols (&) to link the quoted
(non-changing) text together...

=A3&CHAR(10)&";"&B3&"Manager;;;mg"&B3&";v:\Storeid s;mgr"&B3&";;mail;mgr"&B3&";;;;;Admins;;mgr"&B3&"; ;;"

--
Rick (MVP - Excel)


"AMHodgetts" wrote in message
...
Hi,

I have the following text string

store
;S****Manager;;;mgrS****;v:\Storeids;mgrS****.id;; mail;mgrS****;;;;;Admins;;mgrS****;;;

I am trying to replace the 'store' and 'S****' with the contents of 2
other
cells. (basically trying to make my job easier)

The function I attempted to use was;

=(A3)
;(B3)Manager;;;(B3);v:\Storeids;mgr(B3).id;;mail(B 3);;;;;Admins;;mgr(B3);;;

I have also tried changing this by putting quotes and & in at various (and
generally random) points, however all of my attempts have ended in
complete
failure.

Before I end up tearing out all of my hear, would anybody be able to tell
me
if what I am trying to do is even possible. If so - how?

Thanks

Ann
--
Ann Hodgetts