remove first of two lines of text in a cell

[eakenila]

I have an export that returns an excel spreadsheet. In the first column are cells of the following text:

First name last name Site name

I need to delete the first line of text. I’ve tried Find & Replace and entering * CTRL+J (space) but it doesn’t work. The use of CTRL+J (space) * eliminates the second line of text, but I can’t get the reverse to work.

 

[ranman256]

Range("A1").ClearContents (to empty the cell)

to delete the entire row: Rows("1:1").Delete Shift:=xlUp