filmov
tv
Replacing quotes in Excel
Показать описание
How to remove quotes/ inverted commas from Excel data using formula.
------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------
⏲Time Stamps
00:00 Removing inverted commas/ quotes from data in Excel
00:08 Using FIND/ REPLACE (relatively easy)
00:26 Removing quotes using Excel formula (SUBSTITUTE)
00:50 To remove 1 quote mark, you put 4 quote marks
------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------
⏲Time Stamps
00:00 Removing inverted commas/ quotes from data in Excel
00:08 Using FIND/ REPLACE (relatively easy)
00:26 Removing quotes using Excel formula (SUBSTITUTE)
00:50 To remove 1 quote mark, you put 4 quote marks
0:00:15
0:01:29
0:01:27
0:02:04
0:04:15
0:00:59
0:03:13
0:01:31
0:09:24
0:01:31
0:01:22
0:00:42
0:00:27
0:02:02
0:01:28
0:00:33
0:01:04
0:00:36
0:00:45
0:00:34
0:04:43
0:00:51
0:00:26
0:00:43