Pick up 1 name into a new cell from the cell with several names

P

PCA

Hello,

Could somebody help me, how to pick-up one name into a new cell from a cell
with several names in Excel?

Thank you!
 
F

Fred Smith

It depends on what's in the old cell. Provide an example.

Typically it's a combination of searching for a delimiter (eg, comma), and
Mid to pull out the characters you're interested in.

Regards,
Fred.
 

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

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel VBA 0
problems getting this macro to work 23
Auto Insert NEw Row with formatting 2
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Sheet names linking to cell 4
sort by name when user selects name on another worksheet 2
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1

Top