Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: slotcardan
- Content: Threads
- Order by date
-
concatanate
When I use the & and try to join text together as displayed in the help files I get the cells displayed as text. If I use just the & i get the text out of the cells, but they are joined together without a space between the words. If I try using parathensis i get ERR. what am I doing wrong. I...- slotcardan
- Thread
- Replies: 2
- Forum: Office suites general discussion
-
advanced macro commands
I have been using "backsolve" to calculate some engineering flow rates. I have columns about 25 rows deep. I am trying to backsolve for all of these cells. The macro I wrote simply goes down all 25 cells, backsolves and places the result in a cell next to them. The problem I have is backsolve...- slotcardan
- Thread
- Replies: 0
- Forum: Office suites general discussion
-
Interpolation of table data
Excel has a add on function called interpRCT. This function takes numerical data from a group of rows and columns, and can interpolate the values in two dimensions. Does anyone know if there is a similar Lotus add in avialable, and if not a formula or clever @function will do. Thanks- slotcardan
- Thread
- Replies: 4
- Forum: Office suites general discussion
-
Copying and pasting text in Lotus 9.7
I am trying to copy text from one cell location and paste it at the end of text located in another cell. Now I can do this by using ctrl+c, then go to the other cell, F2 for edit, space then ctrl+v. This places the text at the location I have selected. When I try and write a macro for this it...- slotcardan
- Thread
- Replies: 1
- Forum: Office suites general discussion
