# Extracting Data based om Condition

##### Board Regular
Hello all, i want to extract data from column A to column B using formula. If number of characters after the hyphen is less than or equal to 4 then it has to be copied to respective B column cell. Refer example. Thank you.

Book2
AB
2AAAAAA-AAAAAAAA-AA
3BBBB-BBBBBB-BB
4CCCCC-CCCCC
5DDDDDD-DDDDDDDDD-DDD
6EEE-EEEEE-EE
7FFFF-FFFFFF
8GGGG-GGGGGGGG-GGGG
Sheet1

### Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

#### Alex Blakenburg

##### Well-known Member
See if this does what you want.
Formula for B2

Excel Formula:
``=IFERROR(IF(LEN(\$A2)-FIND("-",\$A2)<=4,\$A2,""),"")``

#### steve the fish

##### Well-known Member
Try:

=IF(LEN(A2)-FIND("-",A2)>4,"",A2)

##### Well-known Member

Looks like we all came up with pretty much the same answer.

AB
2AAAAAA-AAAAAAAA-AA
3BBBB-BBBBBB-BB
4CCCCC-CCCCC
5DDDDDD-DDDDDDDDD-DDD
6EEE-EEEEE-EE
7FFFF-FFFFFF
8GGGG-GGGGGGGG-GGGG
9
Sheet1
Cell Formulas
RangeFormula
B2:B9B2=IFERROR(IF(LEN(A2)-FIND("-",A2)<=4,A2,""),"")

##### Board Regular

See if this does what you want.
Formula for B2

Excel Formula:
``=IFERROR(IF(LEN(\$A2)-FIND("-",\$A2)<=4,\$A2,""),"")``
Alex, It is working fine. Thank you

##### Board Regular
Try:

=IF(LEN(A2)-FIND("-",A2)>4,"",A2)
Steve, yours too done the job. Thanks for your time.

#### Alex Blakenburg

##### Well-known Member
Glad we could help and thanks for letting us know.

Replies
0
Views
42
Replies
7
Views
222
Replies
7
Views
98
Replies
14
Views
209
Replies
1
Views
83

1,147,475
Messages
5,741,347
Members
423,656
Latest member
Medrok2021

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back