Extract Text from a text string

		Microsoft Office Forums > Microsoft Excel > Excel
Extract Text from a text string

05-17-2022, 10:10 AM

Logit

Windows 10 Extract Text from a text string

Office 2007

Expert

Join Date: Jan 2017

Posts: 591

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to extract CCIs as separate entries when part of a text string	Cray_Z	Word VBA	5	01-13-2021 03:45 PM
Extract Bold text from string	one4youman	Word VBA	8	04-18-2019 12:31 AM
Formula to Extract text from a text string	Haha88	Excel	2	11-14-2017 01:32 AM
Extract text from a text string	Haha88	Excel	8	02-13-2017 05:06 PM
Extract numbers from a text string	aleale97	Excel	4	02-10-2011 10:33 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:19 PM.