Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Can I make this formula?
0 views
Skip to first unread message
Jason Walter
May 19, 2000, 3:00:00 AM5/19/00
to
I have an excel file that has a product code in Column A. I have to enter
the following in column H: graphics/00000001/(Code from A)tn.jpg. I have
been entering that information for over 1000 product codes and I figured
that there must be a formula that will do it automatically. The product code
is not actually in parenthesis.
the following in column H: graphics/00000001/(Code from A)tn.jpg. I have
been entering that information for over 1000 product codes and I figured
that there must be a formula that will do it automatically. The product code
is not actually in parenthesis.
Is this possible?
Thanks
Jason
Alex Seidanis
May 20, 2000, 3:00:00 AM5/20/00
to
If I got it right, the function you're looking for is
="graphics/00000001/"&A1&"tn.jpg"
typed in H1, and then copied to the rest of the H column.
="graphics/00000001/"&A1&"tn.jpg"
typed in H1, and then copied to the rest of the H column.
Alex
"Jason Walter" <jwa...@ec.rr.com> wrote in message
news:9ghV4.30$C_....@typhoon.southeast.rr.com...
0 new messages