format cells in column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi. Need a little help please. I have a column named 'Names,' In that column,
the names appear as last, first. Is it possible to remove the comma from
every cell in that column? Thank you.
 
Hi Brian

Try using Edit / Replace (ALT E E)

Find what: ,
Replace With: can put nothing or put a space in to separate the names

HTH
 
You must log in or register to reply here.

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

modifying name format within a cell 2
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 Copy cells from one worksheet to another workseet - increment row & do again 0
HELP! Split cell contents to new rows 7
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Help to create a macro 2
VBA - retrieve data on last create named range from previous inserted named range 0

Back
Top