Hi,
how can I remove lines within each cell (multiple lines in one cell with line breaks) that are not starting with a numeric character?
223213 - this line needs to stay
chair - this line needs to be removed
9 - this line needs to stay
needs to be removed
Thanks and best,
Jack
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.
(Note: this requirement is not optional. No help to be offered until the link is provided.)
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
I'm very sorry for cross-posting. This was resolved on the link below and both solution worked perfectly:
https://www.mrexcel.com/forum/excel-...ml#post5320229
Thanks and best,
Jack
I don't think so.Originally Posted by ymcata
Both of them have extra LineFeed at the beginning or end in some occasion like
chair - this line needs to be removed
111111 - this line needs to stay
needs to be removed
Fist one will have extra linefeed at the beginning and the 2nd one always have line feed at the end.
Should be like this
Use in cell like
=GetNumLineRegX(A1)
or
=GetNumLineFilter(A1)
Please Login or Register to view this content.
Jack, You have only posted one site. There are at least two sites that you have crossposted to.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks