1
00:00:00,080 --> 00:00:03,464
Two fictional ticket notes have line breaks inside a cell.

2
00:00:03,464 --> 00:00:07,186
Removing a break with nothing would join neighboring words and make

3
00:00:07,186 --> 00:00:08,878
the note harder to read.

4
00:00:08,878 --> 00:00:12,601
We will preserve the raw column, replace each line feed with

5
00:00:12,601 --> 00:00:14,969
a space, and check three exact phrases.

6
00:00:15,569 --> 00:00:18,379
Column B contains the original note text.

7
00:00:18,379 --> 00:00:23,998
TS-11 reads Check box on one line and before packing on the next.

8
00:00:23,998 --> 00:00:27,610
TS-12 similarly separates Call and customer by Friday.

9
00:00:27,610 --> 00:00:30,420
TS-13 already says Ready for pickup.

10
00:00:30,420 --> 00:00:34,835
Do not overwrite the raw column before verifying a clean copy.

11
00:00:35,435 --> 00:00:40,006
Put Clean note in C1 and leave the source in column B.

12
00:00:40,006 --> 00:00:44,957
A formula in C lets you compare each cleaned phrase against its original.

13
00:00:44,957 --> 00:00:49,147
This controlled step avoids an irreversible Replace All over the only

14
00:00:49,147 --> 00:00:51,052
copy of an imported export.

15
00:00:51,652 --> 00:00:56,261
In C2 enter =SUBSTITUTE(B2,CHAR(10)," ") and fill through C4.

16
00:00:56,261 --> 00:01:00,451
CHAR ten represents the line feed in this practice CSV.

17
00:01:00,451 --> 00:01:04,641
The replacement argument contains one ordinary space, so the words

18
00:01:04,641 --> 00:01:09,669
separated by a break stay separated after the note becomes one line.

19
00:01:10,269 --> 00:01:15,456
C2 must say Check box before packing; C3 must say Call customer by Friday.

20
00:01:15,456 --> 00:01:19,903
C4 should remain Ready for pickup because it had no line break.

21
00:01:19,903 --> 00:01:25,091
If you see boxbefore or Callcustomer, the replacement was empty rather than a space.

22
00:01:25,091 --> 00:01:27,314
Compare all three with column B.

23
00:01:27,914 --> 00:01:30,688
Our sample uses a line-feed character.

24
00:01:30,688 --> 00:01:35,046
Some Windows exports contain a carriage return too, which can remain

25
00:01:35,046 --> 00:01:38,216
even if the note looks like one line.

26
00:01:38,216 --> 00:01:42,971
Inspect the actual data before adding a second substitution for CHAR thirteen.

27
00:01:42,971 --> 00:01:46,933
This exercise does not promise to remove every invisible character.