walkingthecow
New Member
- Joined
- May 22, 2008
- Messages
- 31
I have a huge sheet (which I have attached), and I am trying to figure out how to organize the sheet. Basically I am trying to figure out how to move data from one cell to another in columns. Say for example that under the ORGANIZATION ID we have a number that starts with T (i.e., T011066832), I would like that moved to column TEMP ID, and the B10 can be deleted (this column is being removed anyway). Or, under permanent ID it says TCC103225, I would like the TCC removed. Also, say in PERMANENT ID the number is 4 numbers long (1234), how would I make it append two zeros to the front so it is 6 numbers long? I have attached a sample sheet to give you an idea of what I mean.<SCRIPT language=JavaScript src="http://www.interq.or.jp/sun/puremis...[/XD][XH][/XH][/XR][/RANGE][/XH][/XR][/RANGE]