I have a column with a lot of social security numbers. its stands like this: " xxxxxx-xxxx". in each cell.
So how do i remove the first space, and then remove “-xxxx”. So i only have 6 character left, and without the space in the front?
My data is loading into excel from a https request.
Can anyone please help?