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

software 發表在 痞客邦 留言(0) 人氣()

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

software 發表在 痞客邦 留言(0) 人氣()

Hey Guys.

software 發表在 痞客邦 留言(0) 人氣()

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

software 發表在 痞客邦 留言(0) 人氣()

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,

software 發表在 痞客邦 留言(0) 人氣()

Column A contains 'blocks' of either 7 or 8 cells. For example:

software 發表在 痞客邦 留言(0) 人氣()


I am trying to find a solution for an earlier post. Is there a way for a

software 發表在 痞客邦 留言(0) 人氣()



software 發表在 痞客邦 留言(0) 人氣()

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

software 發表在 痞客邦 留言(0) 人氣()

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

software 發表在 痞客邦 留言(0) 人氣()