Home > IT Answers > Microsoft Windows > What formula is needed for this below in Excel?
Jreifenstein001
185 pts.
 What formula is needed for this below in Excel?
Excel 2003, Excel 2007, Microsoft Excel
What Excel Formula's could i use? First # is starts with 1  back slash 2400.   2400 stays the same only first # changes. example below: [table style="border-collapse: collapse; width: 65pt;" border="0" cellpadding="0" cellspacing="0" width="86"> [col style="width: 65pt;" width="86">[/cOLIST] [tbody] [tr style="height: 12.75pt;" height="17"> [td class="xl66" style="height: 12.75pt; width: 65pt;" height="17" width="86">1/2400[/td] [/tr] [tr style="height: 12.75pt;" height="17"> [td class="xl65" style="height: 12.75pt;" height="17">2/2400[/td] [/tr] [tr style="height: 12.75pt;" height="17"> [td class="xl65" style="height: 12.75pt;" height="17">3/2400[/td] [/tr] [tr style="height: 12.75pt;" height="17"> [td class="xl65" style="height: 12.75pt;" height="17">4/2400[/td] [/tr] [tr style="height: 12.75pt;" height="17"> [td class="xl65" style="height: 12.75pt;" height="17">5/2400[/td] [/tr] [tr style="height: 12.75pt;" height="17"> [td class="xl65" style="height: 12.75pt;" height="17">6/2400[/td] [/tr] [tr style="height: 12.75pt;" height="17"> [td class="xl65" style="height: 12.75pt;" height="17">7/2400[/td] [/tr] [tr style="height: 12.75pt;" height="17"> [td class="xl65" style="height: 12.75pt;" height="17">8/2400[/td] [/tr] [/tbody] [/table]

Software/Hardware used:
Excel
ASKED: April 5, 2010  9:01 PM
UPDATED: April 7, 2010  1:38 AM
RELATED QUESTIONS
Answer Wiki:
If I understand your question correctly, you could use a combination of the <a href="http://office.microsoft.com/en-us/excel/HP100625621033.aspx">CONCATENATE</a>, <a href="http://office.microsoft.com/en-us/excel/HP100698361033.aspx">FIND</a> and <a href="http://office.microsoft.com/en-us/excel/HP100625681033.aspx">LEFT</a> functions. For example, if you have "12400" (you said back slash) in A1, you could put something like this in A2: <pre>=CONCATENATE(LEFT(A1,FIND("",A1)-1)+1,"2400")</pre> If that's not what you mean, please provide more details. -CarlosDL ------------------
Last Wiki Answer Submitted:  April 7, 2010  1:38 am  by  carlosdl   63,535 pts.
All Answer Wiki Contributors:  carlosdl   63,535 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _