Capture the 2nd, 3rd words and so on..

[ALLANT]

Please help me out to provide the correct formula on how to get the desired data or words that i need. Attached is the sample sheet.

[FoxSeaLady]

Hi

The sample sheet did not attach.
To attach the sample GoAdvanced then Manage Attachments select file and submit.

Cheers

[ALLANT]

Dear see attached..

[FlameRetired]

Try this formula in B3 and fill down.

Please Login or Register  to view this content.

[sandy666]

something like this?
=TRIM(MID(A3,SEARCH(" ",A3)+1,LEN(A3)))

[FlameRetired]

And another way.

Please Login or Register  to view this content.