I'm trying to write a function that will replace all 'hard carriage returns' with ' '. I am using the Replace function, but not sure what to put in the second parameter.
Replace (Procedure,"x" ," " );
Anyone have any ideas for me?
Rick
Does anyone know a way to use the value of a cell to determine which cell to use in a formula. Example:
=SUM(CX:C25)
Where X is the value of a cell.
I tried to do something like
=SUM((C(value(B1)):C25)
but that didn't work, any ideas out there???
Thanks!!!!
I am having a little problem using hyperlinks in Excel.
What I am trying to do is create an Excel file with about 15 hyperlinks linked to various other (read only) Excel files. This spreadsheet is to act like a shortcut screen with a description as to what is being selecting.
The problem I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.