View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AMHodgetts AMHodgetts is offline
external usenet poster
 
Posts: 1
Default Copy contenst of a cell into a string

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