Increment Suffix of cell contents by 2

**morton01** · 11-05-2019, 02:39 PM

Hello All,

I have the value abmd-10 in cell b5 and wish to increase the number by 2 to 12 (keeping the prefix abmd-) and put the result in cell b6.
This then needs to repeat down column b ad infinitum.

Can somebody be kind enough to suggest a solution please.
Many thanks,
Tony

**Fluff13** · 11-05-2019, 02:43 PM

How about
=LEFT(B5,FIND("-",B5))&MID(B5,FIND("-",B5)+1,100)+2

**morton01** · 11-05-2019, 03:11 PM

Many thanks Fluff13 - you have saved my index finger!
Kind regards

**Fluff13** · 11-05-2019, 03:15 PM

You're welcome & thanks for the feedback

Increment Suffix of cell contents by 2

LinkBack

Thread Tools

Rate This Thread

Display

Increment Suffix of cell contents by 2

Re: Increment Suffix of cell contents by 2

Re: Increment Suffix of cell contents by 2

Re: Increment Suffix of cell contents by 2

Thread Information

Users Browsing this Thread

Similar Threads

Refining the contents of a combo box drop down list that utilises additem suffix

[SOLVED] Changing a positive or negative value based on the input's suffix, then removing suffix

[SOLVED] Control Button to increment by 1 and then select next cell in row to increment that cell

[SOLVED] Increment down 1 row at a time, copy cell contents to another workbook

number cell increment +1 when dragging down box:what is in the cell when the contents

[SOLVED] How do I had a suffix to a cell i.e. -1,-2,-3?

increment cell reference whilst reading numeric contents

Bookmarks

Bookmarks

Posting Permissions