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
--
Ann Hodgetts

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&";;;"

--
Rick (MVP - Excel)


"AMHodgetts" <(E-Mail Removed)> wrote in message
news:517F7BA1-12A6-45B2-88C0-(E-Mail Removed)...
> 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
> --
> Ann Hodgetts