Value on the right and on the left of a specific character

**trustseller23** · 03-16-2022, 07:46 AM

Chiswell Street Nº1567 2000-232 London

Abbey Road 2718 5000-010 Manchester

I need to extract into a cell the 4 numbers on the left of - and the 3 numbers on the right of - to another cell.

This postal code will always appear in the same structure, 4 numbers with - in the middle and 3 numbers after.

**Andrew-Mark** · 03-16-2022, 07:49 AM

=mid(c16,find("-",c16)-4,4)
=mid(c16,find("-",c16)+1,3)

**TMS** · 03-16-2022, 07:52 AM

Try:

Formula:

Please Login or Register  to view this content.

and

Formula:

Please Login or Register  to view this content.

**trustseller23** · 03-16-2022, 08:03 AM

On both solutions I get "#NAME?"

**TMS** · 03-16-2022, 08:26 AM

No reason why you should get that. Have you typed it or copied it?

Value on the right and on the left of a specific character

LinkBack

Thread Tools

Rate This Thread

Display

Value on the right and on the left of a specific character

Re: Value on the right and on the left of a specific character

Re: Value on the right and on the left of a specific character

Re: Value on the right and on the left of a specific character

Re: Value on the right and on the left of a specific character

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] left padding (with given character)

[SOLVED] Question about LEFT function-How to return a specific character of a string.

Code to delete text left of a specific character

[SOLVED] How to use LEFT and RIGHT to delete last character

[SOLVED] Find text left or right of a specific character in a text string

[SOLVED] How to remove 7 and 8 number character from cell A1 character start from left to right

[SOLVED] Left/Right function in VBA, finding a specific starting character

Bookmarks

Bookmarks

Posting Permissions