merging cells

[Lapchien]

In A2 I have, say 121212, and in S2 I have something else, however I'd like
the content of A2 inside the string contained in S2, something like:

c:\\mypictures\\<contentofA2like121212here>.tif

(obviously the <contentofA2like121212here> is A2)

Any help guys?

Lap

 

[Lapchien]

sorry, i worked it out (not hard after all!)

="c:\\mypictures\\"&A2&".tif"

 

[Peo Sjoblom]

Where within the contents of S2 would you want it?

=SUBSTITUTE(S2,"tif",A2&"tif")

or

=SUBSTITUTE(S2,RIGHT(S2,3),TEXT(A2&RIGHT(S2,3))

note that if A2 is a number with formatted leading zeros
like in 042304 for today than the leading zero will be lost,
in that case you might want

=SUBSTITUTE(S2,"tif",TEXT(A2,"000000")&"tif")

obviously make the same change for the second formula as well

=SUBSTITUTE(S2,RIGHT(S2,3),TEXT(A2,"000000")&RIGHT(S2,3))

 

[Peo Sjoblom]

I thought you said that the string was in S2 and you wanted to merge
S2 and A2. Also note that any leading zeros that are not text will
be gone.