How to extract strings before and after (-) dashes --- macro

[missy22]

I am writing to seek help, in updating the following macro code below, so it can read any strings in column F, before the dashes and display the output in column G. However if Column F has a string (J-), then take number after dash.

Please advice, as I am little unsure how to go about updating this.

I have attached sample data in the attachment, and shows highlighted strings which the code is currently not translating.
Please note the code is behind 'sheet1', for further reference.
Book1.xlsm

Please Login or Register  to view this content.

Desired output in column G
J+34 --> 34
J-67 --> 67

Many Thanks for your time and help.

[AB33]

The attached code works on the sample.

[LJMetzger]

Hi missy22,

Try:

Please Login or Register  to view this content.

To prevent typos from ruining days and weeks of work you need 'Option Explicit' at the top of each code module. This forces you to declare every variable. See http://www.cpearson.com/excel/DeclaringVariables.aspx

Lewis

[missy22]

Hi, thanks for your response, but I am sorry to inform, that I could not get workbook above to work, as both sheet1 and sheet1(2), had the same code behind and was unable to produce the desired output in column G,such as:
J+34 --> 34
J-67 --> 67

Please advice, many thanks.

[jindon]

Please Login or Register  to view this content.

[missy22]

Dear LJMetzger,

thank you for your reply. I am sorry to inform, I tested your code but I am still experiencing the same issue, as the code is failing to convert the strings correctly.

Desired output:
45-45-->45
J+34-->34
S+908-89--> S+908
J-67 -->67


I have updated my code using code, the attachment below.
Book3.xlsm

Please advice further, if possible. many thanks.

[jindon]

Desired output:
45-45-->45
J+34-->34
S+908-89--> S+908
J-67 -->J in your attached file

Please Login or Register  to view this content.

[LJMetzger]

Hi again,

I had to move the following code a little. Please try again. If you still have problems, please let me know.

Please Login or Register  to view this content.

Lewis