merging cells

  • Thread starter Thread starter Lapchien
  • Start date Start date
L

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
 
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))
 
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.
 
Back
Top