Not sure what you're asking, but the INDIRECT function somes to the rescue:
something like =INDIRECT(LEFT(SuppName,2)amp;MID(SuppName,4,4)amp;quot;BDquot;) would make
- Apr 21 Sat 2007 20:36
how to create refrence using first and last words of any supplier
- Apr 21 Sat 2007 20:36
How do I format spreadsheet w/o changing font size?
How do I format a spreadsheet to fit an entire page without changing font
size? It can be spread through several sheets but with the amount of
- Apr 21 Sat 2007 20:36
Changin Cell Formats using VBA
Hey Guys.
- Apr 21 Sat 2007 20:36
3 pg excel wrksht,pg 2 prints formula answers,insert pic behind
3 page excel worksheet, page two prints results of formula/calculation. I
would like to insert a picture behind the results and have it print out as
- Apr 21 Sat 2007 20:36
HOW ?Excel chart auto insert /populate a code based on date
I have a excel spreadsheet that has a front sheet with a date that I type in
.. this then is populate across the other work sheets within the spreadsheet,
- Apr 21 Sat 2007 20:36
Transposing cells
Column A contains 'blocks' of either 7 or 8 cells. For example:
- Apr 21 Sat 2007 20:36
Looking for another way
- Apr 21 Sat 2007 20:36
why is the alignment print different in different computers?
- Apr 21 Sat 2007 20:36
Excel graphed trendline does not match derived equation
I have a scatter-point chart and I have been able to plot the linear
trendline through those scatter points. I then formatted the linear
- Apr 21 Sat 2007 20:36
Help needed in a simple task
Hi , I´d like to know how to solve the following problem, I have a
column of numbers and I want to multiply each number in the column by