Copy contenst of a cell into a string

[AMHodgetts]

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(B3);;;;;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

 

[Rick Rothstein]

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

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