How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask John D Your Own Question
John D
John D, BS Degree in Engineering
Category: Mac
Satisfied Customers: 9666
Experience:  Worked on Macs and PC's for 20+ years.
53785
Type Your Mac Question Here...
John D is online now
A new question is answered every 9 seconds

how do I delete all commas from an excel file with lots of

This answer was rated:

how do I delete all commas from an excel file with lots of data. I need to convert excel contact info into mac address book

Hi,

 

Could you paste the content of one cell so I can see the data and determine the best method to use

 

 

 

 

Customer: replied 5 years ago.
it's a bunch of addresses so could be "company xxx, Inc."

So you want the value

"company xxx, Inc."

to be changes to

"company xxx Inc."

 

Correct?

 

I also need to know which column are these addresses in, and they start from which row

 

 

 

 

 

 

Customer: replied 5 years ago.
exactly

I also need to know which column are these addresses in, and they start from which row so I can send you the formula

 

Or would you prefer to send me your file so I can set the formula up on it directly

 

 

Customer: replied 5 years ago.
columns c through p may have commas. there are 1884 rows of data

Ok try this and if you still need help you can send me the file so I can fix it for you

 

Select columns C thru P

Press the COMMAND + F keys to bring up the Find & Replace dialog box

Click the Replace tab

Type a comma in the 'Find what' field

Type a space in the 'Replace with' field

Press the 'Replace All'

 

Hope this is ok. Let me know if you have any questions, and thank you for clicking Accept if you are satisfied with the solution

 

John D and 4 other Mac Specialists are ready to help you