Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have made a no. of entries while entering the names of files and registers
in a department. I have entered in an alphabetical order eg. Audit file in 'A', Budget (B.Sc.), in 'B', admission registers in 'A', security money register in 'S'. Now i want all registers to be shifted under alphabet 'R'. Is there any way this could be possible. Thanks in anticipation, jay |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
"...Now i want all registers to be shifted under alphabet 'R'. " So you have things identified as Registers in various columns and you want to put them all into the R column? Is that what you mean? How are Register entries to be recognized - do they all have the word register on the end? Do they have a word like register in them (Register, register, Registers, Reg. etc) - what are those words? Do entries start in R1? Are there entries in the R coulmn that now need to be removed from that column or do you want to add to what is already there? Where do column entries start - the second row? How long is each column or can it be any length? regards Paul On May 13, 10:41*am, Jay wrote: I have made a no. of entries while entering the names of files and registers in a department. I have entered in an alphabetical order eg. Audit file in 'A', Budget (B.Sc.), in 'B', admission registers in 'A', security money register in 'S'. Now i want all registers to be shifted under alphabet 'R'. Is there any way this could be possible. Thanks in anticipation, jay |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why can't I sort new Excel entries after I exceed 1115 lines? | Excel Discussion (Misc queries) | |||
Checking a database/excel sheet for new entries | Excel Programming | |||
Checking a database/excel sheet for new entries | Excel Programming | |||
any way to alphabetically sort text entries in EXCEL? | Excel Discussion (Misc queries) | |||
how can I sort alphanumeric entries by number in excel | Excel Worksheet Functions |