conditionally copying cells

R

Ron

Thanks to some great help last week, I am using the below formula to
conditionally copy the contents of cells.

=IF(ISNUMBER(SEARCH("[ Named",C[4])),C[4],"")

I need to expand on this by limiting what is copied from C[4]. I still need
to conditionally copy the contents of the 4th cell over, but I need to ignore
the first 20 characters AND the last 2 characters.

My input data looks like:
[ Named Symbology - T_Gas Meter High Pressure ]
001Default TextTextSymbology
002Default PointPointSymbology

[ Named Symbology - T_Gas Misc ]
001Default TextTextSymbology
002Default PointPointSymbology

[ Named Symbology - T_Gas Valve High Pressure ]
001Default TextTextSymbology
002Default PointPointSymbology
 
D

Dave Peterson

You have lots of replies at your other post.
Thanks to some great help last week, I am using the below formula to
conditionally copy the contents of cells.

=IF(ISNUMBER(SEARCH("[ Named",C[4])),C[4],"")

I need to expand on this by limiting what is copied from C[4]. I still need
to conditionally copy the contents of the 4th cell over, but I need to ignore
the first 20 characters AND the last 2 characters.

My input data looks like:
[ Named Symbology - T_Gas Meter High Pressure ]
001Default TextTextSymbology
002Default PointPointSymbology

[ Named Symbology - T_Gas Misc ]
001Default TextTextSymbology
002Default PointPointSymbology

[ Named Symbology - T_Gas Valve High Pressure ]
001Default TextTextSymbology
002Default PointPointSymbology
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Searching for multiple strings and return multiple solutions 2
copy select characters from specified cells. 3
Cell format crosstalk 0
Array with many cells from a row but not in order or together 11
Copy & Paste Conditional Formatted duplicates w/vba 0
conditional formatting, filtering then copying to another sheet 0
A Huge Conditional Format Challenge.... 2
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3

Top