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. Sample.xlsABCDEFG1LOGINNAMELASTNAMEFIRSTNAMEPERMANENTIDORGANIZATIONIDTEMPIDBUILDING2vmcmullDoeJaneTCC1032253444T022114233G503vtalaveDoeJane75985179201T051816942B104vadamsDoeJane37825T011066832B105vhullDoeJane35540T062976961B106vseagoDoeJane37825T032687383B107vcmayeuDoeJane7832747673T121957903B108shorv01DoeJane7669T122482259B109tonsv00DoeJane75397963472T040555109B1010vmaithDoeJane12697T011956786B1011gillelvkDoeJane13199T060388051B1012vwsearsDoeJane791278865T022363708F6413vfsablaDoeJane7667226985T083154563G4514vasummeDoeJane99737939694T112897379B1015vkvoDoeJane7565156668T102731587G3916wakoziaDoeJane7868379243T010611639F6117wkwiszoDoeJane76458633981T011969546B1018walter.p.plantDoeJane6834717351T030435702B1019wscrawfDoeJane56940820574T110939178B10Sheet1

If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.

Moving Cells Around

Thread starter walkingthecow
Start date Jun 18, 2008

walkingthecow

New Member

Jun 18, 2008

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]