LinkBack URL
About LinkBacks
To avoid compromise of personal information, I would like get help to do a macro to remove the first five of social security number and leave only the last four. I appreciate any help.
To avoid compromise of personal information, I would like get help to do a macro to remove the first five of social security number and leave only the last four. I appreciate any help.
cell.value = right(cell.text, 4)
Entia non sunt multiplicanda sine necessitate
For example, select the cells of interest, and the run this:
Sub x() Dim cell As Range For Each cell In Selection cell.Value = Right(cell.Text, 4) Next cell End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks