select part of a cell value string

G

Guest

Hi,

I have a column of text (postcodes/zipcodes) in the following formats L3*1MT
or L12*3DE. What i want to do is have a second column that reads the first
column value and removes the *data, leaving just the L3 or L12. How can i do
this??

Thanks

Rich
 

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

Subtotal Question with a twist 3
VLookUP formula help! 5
Hide cell formula without password protecting sheet 4
">=" usage in a function 3
Cell References 1
how do I select multi values from a list 1
MATCHING A VALUE IN A CELL TO A COLUMN OF VALUES IN ANOTHER SHEET 1
Cascading Data Validation Drop Down Lists 3

Top