Community Profile

photo

Lexington Stoyell


Last seen: ungefär 3 år ago |  Active since 2018

Followers: 0   Following: 0

Statistics

  • Thankful Level 2
  • First Review
  • Thankful Level 1

View badges

Feeds

View by

Question


How to keep 0s when converting data type?
I currently have a 6x4 cell. Most of the cells are populated with numbers, while the remaining have zeros. Using 'isnumeric' I h...

ungefär 6 år ago | 1 answer | 0

1

answer

Question


How to add zeros to the end of cells
I am looping through data, which are of various lengths. I want to create a cell that will attach zeros to the end of the cells ...

ungefär 6 år ago | 1 answer | 0

1

answer

Question


How to compare tables/cells/characters?
Is there any way to compare (greater than or less than) using tables? Or is there a way to compare using cells or as a character...

ungefär 6 år ago | 1 answer | 0

1

answer

Question


Convert a Cell to String
Can you convert a cell to a string? How do you do so? Are there better types to use instead of a string? Or should you convert a...

ungefär 6 år ago | 0 answers | 0

0

answers

Question


How to use a variable name as an Excel range?
I want to be able to use my variable, Value_Col, as the range which the Excel file references to find the column. The column is ...

ungefär 6 år ago | 1 answer | 0

1

answer

Question


How to extract certain Excel columns?
I would like to extract columns based on their name (the first row of the column). These columns are randomly ordered.

ungefär 6 år ago | 3 answers | 0

3

answers

Question


How to convert a cell to a string?
I have attempted to convert a cell to a string using cellstr (which doesn't work)... I need a column of cells (all containing nu...

ungefär 6 år ago | 0 answers | 0

0

answers

Question


How to separate an Excel column into two columns?
I have a column in an Excel sheet that I would like to separate into two columns. The numbers are separated by a comma (Ex. [1, ...

ungefär 6 år ago | 0 answers | 0

0

answers

Question


How to extract multiple numbers from an Excel cell?
I am attempting to create a matrix for both the values and then two for the limits (one for the upper limit, and one for the low...

ungefär 6 år ago | 0 answers | 0

0

answers

Question


What is the difference between xlsfinfo and xlsread?
I currently have a code where the file is read in using xlsfinfo. Below I have attached a code that requires xlsread (I think an...

ungefär 6 år ago | 1 answer | 0

1

answer

Question


How to Define a Checkbox?
Currently when I run through a code, which I have two checkboxes in, the second is undefined. I was given the original code to u...

ungefär 6 år ago | 1 answer | 0

1

answer

Question


How to search an Excel file for a certain column, then save that entire column?
I am working on a project where columns could be out of order, so I cannot depend on saving data from these columns as they will...

ungefär 6 år ago | 1 answer | 0

1

answer