Removing preceeding and trailing characters

[Spiritseeker]

Hi all,

I am trying to create a CSV file to import all of our workers into a payroll software. Unfortunately the list of workers that I have been given to work with has a first and a last name together in one cell. I need to split them into separate cells so the data ends up in the right field in our software. By importing external data and separating the names with the comma as a delimiter, I have ended up with the first name in one cell and the second in another, which is exactly what I need. However, this process also ends up putting a quotation mark in front of the first names in the cells in column A, and a quotation mark after the second name in the cells in column B. I remember someone helped me to removing trailing spaces with a macro once, and I am hoping the same theory can be applied to make two macros - one to remove preceding quotation marks, and one to remove trailing quotation marks. The only trouble is, I know no VBA whatsoever, and don't even know how to make a macro unfortunately. Would someone mind letting me know if what I need is possible, and then - literally step by basic step - explain how to make a macro and provide the code to paste into it?

Or alternatively, does someone know how to separate the data into two columns without the quotation marks? (There aren't any quotation marks on the original data).

many thanks in advance

[martindwilson]

why not use find replace? find " replace nothing?

[Spiritseeker]

Why not indeed - thanks for the obvious and simple solution. I do tend to overcomplicate things sometimes!