| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
=LEFT(A1,FIND("*",A1)-1)
HTH Jason Atlanta, GA "rich_j_h" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| up to 7 functions? | Excel Worksheet Functions | |||
| Please Help...How can I do this? Select a cell | Excel Worksheet Functions | |||
| Need to find the right-most cell value in a string of cells | Excel Worksheet Functions | |||
| How do I test a cell for part of text | Excel Worksheet Functions | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Hybrid Mode
