Issue with RIGHT/LEFT formula

[klutzington]

I have used the RIGHT/LEFT formula in the past to pull chunks of data from workbook, but now the data I'm recieving has changed. Example below:


Example of the data I'm being provided (the spacing and punction are identical and the number next to the state is random): Lastname, Firstname NumberState City (Smith, John 3PA HBG)

What data I need to extract from the cell : Firstname Lastname (John Smith)


I've tried RIGHT/LEFT functions, but the spacing within the cell makes my formula crash and burn. Any ideas?

[azumi]

Yhe position is always like this?

Smith, John 3PA HBG

[klutzington]

Yes the position is always the same, but the number is random and obviously the state and city initials change as well.

[sktneer]

Assuming you have text in A1, then

Please Login or Register  to view this content.

[klutzington]

Thank you sktneer! Works like a charm...