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.

--

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 Functio

--
Message posted from http://www.ExcelForum.com

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


"tolgag " wrote in message
...
Try this :

Function removePar(pstrName as String) as String

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

End Function


---
Message posted from http://www.ExcelForum.com/