ExcelBanter - format cells in column

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - format cells in column (https://www.excelbanter.com/excel-discussion-misc-queries/10001-format-cells-column.html)

Brian L

format cells in column

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.

STFC

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

"Brian L" wrote:

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.

All times are GMT +1. The time now is 10:10 AM.