Sally has attended:
Excel Intermediate course
Removing " from a cell
Hi,
i know there is a quick and easy way of doing this without going into each one adn deleting it, i was just wondering if you could help me.
I have exported some data into excel and now in each cell the data is seperated buy "" i.e. "sally" how do i remove that quickly?
thanks
RE: Removing " from a cell
Dear Sally
Thank you for attending Excel Intermediate Course. I hope you enjoyed the training.
This is a common error that appears when you try import data from other source.
The solution is quiet Straight forward.
Step 1: Click anywhere inside the data
Step 2: Choose [b]Edit> Replace