First time on this website. I hope that someone can help me.
I have a spreadsheet that was exported from one program that will need to be uploaded into another. To simply the question, I will only address the contents of any given cell in a column, and how I wish for data in another column to be shown, based upon the first.
Let's say starting at column "P", row "1) I have the following data listed down the column:
1
3
12
0
04W
5
The cell above the 5 is intentionally blank.
I want to have a column created where:
1) Any number greater than 0 and less than ten will result in '0x, where x is the number. So for the first two rows, it would show '01 and '03. The apostrophe needs to be shown. I assume that I can park the '0 somewhere and use the concatenate function for that.
2) a two digit number would simply be repeated in the new column
3) A zero would be repeated in the new column
4) Alphanumeric entries would be repeated in the new column
4) The blank cell would be repeated in the new column.
The columns need not be adjacent but the results must appear on the same respective rows.
Somehow I know that I need to use functions such as "isnumber", concatenate, as well as possibly the "if" & "and" functions. I just cannot figure out how to put this all together.
Any assistance will be greatly appreciated.
BB
Bookmarks