Replace a character in a data vector with the next character in another data vector

**t2o5ive** · 07-21-2016, 10:48 AM

I have a row of values, for example:

14112

and another row:

abd.krtvg.ehrg..ewx.rewt

For each '.' I need the next number in the first row to replace it.
The final line should look like:

abd1krtvg4ehrg11esx2rewt

Any suggestions?

Thanks

**shg** · 07-21-2016, 11:19 AM

Welcome to the board.

	A	B	C	D
2	abd.krtvg.ehrg..ewx.rewt	14112	abd1krtvg4ehrg11ewx2rewt	C2: =t2o(A2, B2)

Please Login or Register  to view this content.

**walruseggman** · 07-21-2016, 11:33 AM

Slightly different approach, both as a UDF:

Please Login or Register  to view this content.

And as a sub:

Please Login or Register  to view this content.

Replace a character in a data vector with the next character in another data vector

LinkBack

Thread Tools

Rate This Thread

Display

Replace a character in a data vector with the next character in another data vector

Re: Replace a character in a data vector with the next character in another data vector

Re: Replace a character in a data vector with the next character in another data vector

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to drag a formula on one vector and reference cells on the perpendicular vector

How to count a description in a vector if a + value is in the sum of another vector

Lookup vector - result vector

Create shorter vector from a vector of unknown length

Charting from data vector in VB

Manipulating data in a vector

[SOLVED] How do I draw 3D vector arithmetic, showing vector subtraction?

[SOLVED] importing undelimited text file data, character-by-character

Bookmarks

Bookmarks

Posting Permissions