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
Excel Formula Question 2
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Map characters to their relative positions in a cell 3
VB to search a value in an array from a sheet then write another c 0
Who Can Expand Chip Pearson's procedure ExportToTextFile? 8
Syntax to combine MID() and FIND("LastPost:") to extract the LastPost Date ? 3
VB Generated Hyperlinks 1

Top