Thread
:
Extract Text from a text string
View Single Post
05-17-2022, 10:10 AM
Logit
Windows 10
Office 2007
Expert
Join Date: Jan 2017
Posts: 533
In C4 paste :
Code:
=RIGHT(A4,LEN(A4)-SEARCH("-",A4))
and copy down the column. Now hide column C.
In D4 paste :
Code:
=SUBSTITUTE(C4, ",", "")
and copy down the column.
Column D displays your final result using Column C as a HELPER COLUMN.
Logit
View Public Profile
Find all posts by Logit