Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Brian L
 
Posts: n/a
Default 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.
  #2   Report Post  
STFC
 
Posts: n/a
Default

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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Format cells as date bay Excel Discussion (Misc queries) 3 January 26th 05 05:34 PM
calculate which cells in column A will give me the total of column Ken Excel Worksheet Functions 4 January 6th 05 06:25 AM
How do I ROUNDUP a Column of cells on a worksheet template? house mouse Excel Worksheet Functions 2 December 16th 04 06:49 PM
Protected cells -automatically format to a different color Fred Evans Excel Discussion (Misc queries) 9 December 3rd 04 12:59 PM
When I select "format cells", the format dialog box does not disp. Andy S. Excel Worksheet Functions 2 November 23rd 04 03:49 AM


All times are GMT +1. The time now is 04:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"