Please stop shouting at us (turn off your caps lock).
If you will search, you'll find numerous previous posts that address this
topic. Here is a portion of one of those posts...
You can add a new column to your query for the first name, and a column for
the last name. You can then use the values from the query in your forms,
reports, and other queries. I'd probably make this into an update query and
clean up my table and maintain the two fields from this point forward and
delete the combined field.
FName: Left([Name],InStr([Name],",")-1)
LName: Mid([Name],InStr([Name],",")+1)
--
Rick B
SJW said:
I HAVE A LARGE DATA BASE THAT WAS CREATED IN A FORMAT OF THE WHOLE NAME IS
IN
ONE CELL I NEED TO SPLIT "JONES, BILL" WHICH ARE IN ONE CELL INTO TWO
CELLS
THANKS IN ADVANCE FOR YOUR HELP
SJW