Remove specific information from cell in Excel?

Question

I have a cell in Excel w/ this: LEX\NAME. I want to remove LEX\ while leaving behind NAME. I need to do this for several cells and would like to have a formula to remove that specific part from the cells (the LEX\).

Answer 1

If you absolutely need a formula:
=MID(Range,5,50) (I certainly hope no one's name has more than 50 characters)

But Find & Replace will be better, the formula will need extra steps to convert the data back to text intead of formulas; Copy and Paste Special... | Values.

Answer 2

CLick on the first cell.

Hit CTRL and F

Select the replace Tab

In Find, Type in LEX\

In the replace, leave blank

Hit replace and the LEX\ will be replaced with nothing which is just deleting it. Keep hitting replace until you are done.

Answer 3

highlight all the cells involved
go to 'Edit'
click 'Replace'
Type 'LEX\'
leave the replace blank

then 'replace all'

Answer 4

highlight all the cells involved
go to 'Edit'
click 'Replace'
Type 'LEX\'
In replace with type NAME
then 'replace all'

Answer 5

Though you have not made question very simple. I still manage to understand that. I think you want Lex and Name in two diffrent cells. Use This formula
Lex=LEFT(A1,FIND("/",A1,1)-1)
Name=right(a1,len(a1) -
find("/",a1,1))

Where A1=Lex/Name
Best of Luck

Answer 6

click on the cell and push backspace