Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel string manipulation

Status
Not open for further replies.

clovisc

Programmer
Aug 27, 2012
4
0
0
GB
Hi,

I have an Excel spreadsheet with about 17000 lines.

In certains cells of col B, there is a string starting with "(If ISCunable to resolve, " then the rest of the string may differ.

I need to cut the string out of the cell, and paste it into the cell next to it (col C).

I found some code for matching strings, and copying to a new sheet, but I have no idea how to adapt it, it's chinese to me! :)

Any help much appreciated.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top