inserting data in a column based on data in another

B

Bob

I have data such as A2 Mary Jane Doe, A3 Mary Smith, A4 David Jones, A5
David Smith Jones, A6 Mary Jones, A7 Jack-James-John Taylor and so on.

I would like Column B to reflect the first names such as A2 Mary Jane, A3
Mary A4 David, A5 David, A6 Mary, A7 Jack-James-John.

There are 21 different possible names in column A and the number of rows
from month to month will vary.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove specific cells in a column. 2
Total columns Based on another cells value 4
Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows 2
Return next non-Blank Cell in a Column ? 3
need macro to filter data from multiple sheets in a worksheet 5
column to row draging 1
Count the remaining weekdays in a data range excluding holidays and start/end dates 5
Create if partial match then copy and paste data from one cell to another 1

Top