I would like to convert a text social security number (###-##-####) to a
numerical format (#########) so that it can search using vlookup functions.
Any help is greatly appreciated.
-Joe
I would like to convert a text social security number (###-##-####) to a
numerical format (#########) so that it can search using vlookup functions.
Any help is greatly appreciated.
-Joe
it depends on whether it is numeric formated with the dashes or Text with the
dashes embedded.
goto <format><cells><number> and select general
if the dashes are still there it is text.
select the cells and use find replace (Find the dash replace with nothing)
the cells will still be text, so enter 1 in a cell copy it select the SSN
cells and paste special Multiply
"Joe" wrote:
> I would like to convert a text social security number (###-##-####) to a
> numerical format (#########) so that it can search using vlookup functions.
> Any help is greatly appreciated.
>
> -Joe
One way would be as follows:-
A1 contains SS number so in B1 enter the following
=(LEFT(A1,3)&MID(A1,5,2)&RIGHT(A1,4))*1
"Joe" wrote:
> I would like to convert a text social security number (###-##-####) to a
> numerical format (#########) so that it can search using vlookup functions.
> Any help is greatly appreciated.
>
> -Joe
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks