Extracting from one cell to another cell

[Michael Koerner]

I would like to know if it is possible to extract information from one cell into
another cell in the same row.

I have for example in A1: Jones (Smith) I would like to remove (Smith) from A1:
and insert it into B1: as Smith. there may or may not be a () selection in
column A.

Any help or suggestions as always, are greatly appreciated.

 

[tolgag]

Try this :

Function removePar(pstrName as String) as String

Dim strResult as String
strResult = Replace(pstrName, "(", " ")
strResult = Trim(Replace(strResult, ")", " "))
removePar = strResult

End Functio

 

[Michael Koerner]

Not being very knowledgeable in this area, I am assuming that what you suggested
removes the () I would also like to have what was between the () moved to
another column, same row.

--

Regards
Michael Koerner


Try this :

Function removePar(pstrName as String) as String

Dim strResult as String
strResult = Replace(pstrName, "(", " ")
strResult = Trim(Replace(strResult, ")", " "))
removePar = strResult

End Function