LinkBack URL
About LinkBacks
Because the user has given Alt+Enter to create new lines in the cell for each entry.
In B1 Cell
=SUBSTITUTE(A1,CHAR(10)," ")
Drag it down…
Copy the formula cells and use paste special and change it to values.
Because the user has given Alt+Enter to create new lines in the cell for each entry.
In B1 Cell
=SUBSTITUTE(A1,CHAR(10)," ")
Drag it down…
Copy the formula cells and use paste special and change it to values.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks