Excel VB

N

Nigel Forge

I have a project to convert text data in an Excel spreadsheet (2003) and need
some help please. I have numerous character strings of variable length (10 to
70 chars) and need to find one character in the text and remove all text
before and including that character. So from Oil SealBearingSS$Oil Seal
fitting, I would need Oil Seal fitting. Any help is much appreciated as
always.

Nigel Forge
 
J

Jim Thomlinson

Why VB? How about just using this formula...

=MID(A1, FIND("$", A1)+1, 256)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel macro 5
Data validation, mandatory and restricted field length for excel vbs 10
VBA to read "form" 1
Map characters to their relative positions in a cell 3
Excel Formula Question 2
VB Generated Hyperlinks 1
Who Can Expand Chip Pearson's procedure ExportToTextFile? 8
Syntax to combine MID() and FIND("LastPost:") to extract the LastPost Date ? 3

Top