Concatenate?

[Howie]

I have a column of first and last names in Excel that includes a comma that I want to take out. How can I do this? For example, I have "Joe, Smith" in one column. How can I get rid of the comma so it reads "Joe Smith"? I obviously don't want to do this by hand. Would the concatenate function work somehow?

 

[Alan]

With a formula, with Joe, Smith in A1
=SUBSTITUTE(A1,","," ")
Copy to end of range then Copy > Paste Special > Values > OK

An easier way, highlight the range,
Edit > Replace
Replace ,
Replace With > Leave Empty
Replace All
OK

I have a column of first and last names in Excel that includes a comma

that I want to take out. How can I do this? For example, I have "Joe,
Smith" in one column. How can I get rid of the comma so it reads "Joe
Smith"? I obviously don't want to do this by hand. Would the concatenate
function work somehow?

 

[Dave R.]

It seems weird to have it "Joe, Smith" rather than "Smith, Joe".

If it is really "Joe, Smith" you can just select that range, press CTRL-H,
enter search for , and replace with nothing (leave blank). then replace
all.

If it is "Smith, Joe" in A1, you can use a formula like

=MID(A1,FIND(",",A1)+2,99)&" "&LEFT(A1,FIND(",",A1)-1)

I have a column of first and last names in Excel that includes a comma

that I want to take out. How can I do this? For example, I have "Joe,
Smith" in one column. How can I get rid of the comma so it reads "Joe
Smith"? I obviously don't want to do this by hand. Would the concatenate
function work somehow?

 

[Don Guillett]

try this
for each c in selection
c.value=application.substitute(c,",","")
next

--
Don Guillett
SalesAid Software
(e-mail address removed)

I have a column of first and last names in Excel that includes a comma

that I want to take out. How can I do this? For example, I have "Joe,
Smith" in one column. How can I get rid of the comma so it reads "Joe
Smith"? I obviously don't want to do this by hand. Would the concatenate
function work somehow?

 

[joannanpa]

If this is a one-time action, then simply use the find/replace option
where you enter a comma in Find and leave Replace blank. You can als
set to search by column. Commas will be deleted

 

[Guest]

-----Original Message-----
I have a column of first and last names in Excel that

includes a comma that I want to take out. How can I do
this? For example, I have "Joe, Smith" in one column.
How can I get rid of the comma so it reads "Joe Smith"? I
obviously don't want to do this by hand. Would the
concatenate function work somehow?

.
Just use the search and replace function. Search for .

and leave the replace field blank,