Hi all,
I have an excel worksheet in which column H has info such as "house 12 in Main St, Town".
I am trying to extract the first part "house 12 in" to column K. This works fine.
However, column H has not removed the "n " and the space after "n".
The code I am using is:
Formula:Please Login or Register to view this content.
I am just using 2 rows as a test - when I have the code working correctly, I will use it for several thousand rows.
Has anyone any idea how to correct this error, please.
Many thanks in advance.
Bookmarks