Does anyone know how to remove the first lines from each cell in 1 column (H) of a sheet of exported emails?
excel lines in cell to be deleted @2017-05-30, 20_22_20.png
Does anyone know how to remove the first lines from each cell in 1 column (H) of a sheet of exported emails?
excel lines in cell to be deleted @2017-05-30, 20_22_20.png
Last edited by piecevcake; 05-30-2017 at 04:48 AM.
So many potential caveats, but this will work for the example provided (assuming input in cell H1)
=RIGHT(H1,LEN(H1)-(FIND(CHAR(10),H1,FIND("To:",H1)+2)))
Note, however, you lose the carriage returns in the original note, if any.
Pauley
--------
If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
Thanks for that Pauley,
Could you please help me with how to use that code?
I was thinking of a VBA macro that would go through all the cells in the column, (but the site won't let me edit my question...)
It is not VBA code, it is a formula. So, in another cell, lets say Z1, put that formula in and then 'drag' that formula down to as many rows as you need.
ok... would I then paste values from the new column to the original column and the lines would be gone?
You could, have you tried it? As currently defined, if you put that formula into Z1, then H1 would remain unchanged, but Z1 would contain the text without the header info. You could then copy/cut the data from Z1 into H1 if you wish.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks