Extracting from one cell to another cell

  • Thread starter Thread starter Michael Koerner
  • Start date Start date
M

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.
 
Try this :

Function removePar(pstrName as String) as String

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

End Functio
 
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
 
Back
Top