I have a column with mixed alphanumeric data.
Data example:
^-1478847851--001
I need to scrub the symbols so just the numbers appear (i.e.1478847851001).
Thanks,
I have a column with mixed alphanumeric data.
Data example:
^-1478847851--001
I need to scrub the symbols so just the numbers appear (i.e.1478847851001).
Thanks,
Perhaps with Find "-" & Replace ""
Rgds
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
You could use this UDF...
Please Login or Register to view this content.
HTH
Regards, Jeff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks