HOW TO MOVE SECECT DATA TO ANOTHER CELL

V

Victor Costello

IN MY CUSTOMER LIST IN COLUMN B, I HAVE SOME ENTRIES WITH "DBA STORE NAME"
(QUOTATION ADDED FOR REFERENCE . STORE NAME IS DIFFERENT FOR EACH STORE)
AND SOME WITH THE ADDRESS OF THE STORE. I WANT TO MOVE ALL THE ENTRIES WITH
"DBA STORE NAME" TO THE COLUMN NEXT TO IT, LETS SAY C. IS THERE A WAY TO DO
THIS?

IN COLUMN E, I HAVE SOME ENTRIES WITH "SUITE #" (# IS DIFFERENT FOR EACH
STORE) THAT I WANT TO MOVE INTO COLUMN D WHICH CONTAINS THE ADDRESS OF THE
STORE. I WANT THE "SUITE #" TO BE TO THE RIGHT OF THE ADDRESS, I.E. 123 MAIN
ST STE 102. IS THERE A WAY TO DO THIS?

THANKS FOR YOUR HELP.

VICTOR
 
V

Victor Costello

Sorry. It wasn't intentional.



In my customer list in column B, I have some entries with "dba Store Name"
(quotation added for reference. Store Name is different for each store) and
some with the address of the store. I want to move all the entries with "dba
Store Name" to the column next to it, let's say C. Is there a way to do
this?



In column E, I have some entries with "Suite #" (# is different for each
store) that I want to move into column D which contains the address of the
store. I want the "Suite #" to be to the right of the address, e.e. 123 MAIN
ST STE 102. Is there a way to do this?



Thanks again,

victor
 
Top