Microsoft Office Forums - View Single Post - Extract Text from a text string

Thread: Extract Text from a text string

View Single Post

Old

05-17-2022, 10:10 AM

Logit

Logit is offline

Logit uses Windows 10

Windows 10 Logit uses Office 2007

Logit uses Office 2007

Office 2007

Expert

Join Date: Jan 2017

Posts: 533

Logit is a jewel in the rough

Logit is a jewel in the rough

Logit is a jewel in the rough

Default

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.

Reply With Quote