用于在半冒号之间提取字符串的宏 [英] Macro to extract string between semi colons

问题描述

我正在尝试构建一个在半冒号之间提取字符串的宏。例如，

I am trying to build a macro that extracts a string between semi colons. For example,

记录号。 2551：未知的数字组合。 （＃40 :: BT12345678）（; BT12345678 ; 0）

我需要提取字符串  BT12345678 在两个半冒号之间并将其复制到它旁边的单元格。文档中有许多这种类型的行，尽管所需的字符串不是
总是在同一个地方（但总是在两个半冒号之间）。此宏应该对所有行运行，直到文档结束。我希望有人可以帮助我。

I would need to extract the string BT12345678 which is between the two semi colons and copy that to the cell next to it.There are many rows of this type down the document, though the needed string is not always in same place (but always between the two semi colons). This macro should run for all the lines till the end of the document. I hope somebody can help me.

谢谢。

推荐答案

我正在尝试构建一个提取半冒号之间字符串的宏。例如，

I am trying to build a macro that extracts a string between semi colons. For example,

记录号。 2551：未知的数字组合。 （＃40 :: BT12345678）（; BT12345678 ; 0）

我需要提取字符串  BT12345678 在两个半冒号之间并将其复制到它旁边的单元格。文档中有许多这种类型的行，尽管所需的字符串不是
总是在同一个地方（但总是在两个半冒号之间）。此宏应该对所有行运行，直到文档结束。我希望有人可以帮助我。

I would need to extract the string BT12345678 which is between the two semi colons and copy that to the cell next to it.There are many rows of this type down the document, though the needed string is not always in same place (but always between the two semi colons). This macro should run for all the lines till the end of the document. I hope somebody can help me.

谢谢。

宏？你的意思是Excel？

Macro? You mean for Excel?

你在错误的论坛。这是VB Net开发人员的论坛。

You're in the wrong forum. This is a forum for VB Net developers.

这篇关于用于在半冒号之间提取字符串的宏的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！