Concatenate?

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

Guest

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?
 
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
Howie said:
I have a column of first and last names in Excel that includes a comma
Click to expand...
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?
 
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)


Howie said:
I have a column of first and last names in Excel that includes a comma
Click to expand...
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?
 
try this
for each c in selection
c.value=application.substitute(c,",","")
next

--
Don Guillett
SalesAid Software
(e-mail address removed)
Howie said:
I have a column of first and last names in Excel that includes a comma
Click to expand...
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?
 
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
 
-----Original Message-----
I have a column of first and last names in Excel that
Click to expand...
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 .
Click to expand...
and leave the replace field blank,
 
Back
Top