How to prepare data in Microsoft Excel - Revision history

Frank@tygron.nl at 15:54, 30 January 2024

2024-01-30T15:54:10Z

2023-02-21T16:42:02Z

Removing spaces and other characters in bulk from ranges of cells

← Older revision		Revision as of 16:42, 21 February 2023
Line 26:		Line 26:
	File:ExcelReplaceAllBtn1.jpg\|6. Select Replace All		File:ExcelReplaceAllBtn1.jpg\|6. Select Replace All
	</gallery>		</gallery>

			{{article end
			\|seealso=
			* [[Excel]]
			* [[Var (Excel)]]
			}}

2023-02-21T16:41:06Z

← Older revision	Revision as of 16:41, 21 February 2023
(No difference)

2019-12-16T10:54:27Z

← Older revision		Revision as of 10:54, 16 December 2019
Line 1:		Line 1:
	On this page some general information is given about how to convert data in ~~your~~ spreadsheet.		On this page some general information is given about how to convert data in a spreadsheet.
	Microsoft Excel and other spread sheet programs are known to be able to read many data types, however, sometimes this data is interpreted differently than desired. Below are tips to convert/ process data in spread sheets after import and prior to further processing in the Tygron Platform.		Microsoft Excel and other spread sheet programs are known to be able to read many data types, however, sometimes this data is interpreted differently than desired. Below are tips to convert/ process data in spread sheets after import and prior to further processing in the Tygron Platform.

2019-12-16T10:15:55Z

← Older revision		Revision as of 10:15, 16 December 2019
Line 1:		Line 1:
			On this page some general information is given about how to convert data in your spreadsheet.
	Microsoft Excel and other spread sheet programs are known to be able to read many data types, however, sometimes this data is interpreted differently than desired. Below are tips to convert/ process data in spread sheets after import and prior to further processing in the Tygron Platform.		Microsoft Excel and other spread sheet programs are known to be able to read many data types, however, sometimes this data is interpreted differently than desired. Below are tips to convert/ process data in spread sheets after import and prior to further processing in the Tygron Platform.

2019-11-26T15:52:29Z

← Older revision		Revision as of 15:52, 26 November 2019
Line 7:		Line 7:

	==Converting text to numbers==		==Converting text to numbers==
	When imported data in an excel has columns with number values alligned to the left, this usually means the numbers are interpreted as text. In the following article from Microsoft it is explained how to easily convert columns with text to numbers:		When imported data in an excel has columns with number values alligned to the left, this usually means the numbers are interpreted as text.In the following article from Microsoft it is explained how to easily convert columns with text to numbers:
	[https://support.office.com/en-us/article/convert-numbers-stored-as-text-to-numbers-40105f2a-fe79-4477-a171-c5bad0f0a885 Convert numbers stored as text to numbers]		[https://support.office.com/en-us/article/convert-numbers-stored-as-text-to-numbers-40105f2a-fe79-4477-a171-c5bad0f0a885 Convert numbers stored as text to numbers]
			[[File:Aligned_to_the_left.png]]


	==Removing spaces and other characters in bulk from ranges of cells==		==Removing spaces and other characters in bulk from ranges of cells==

2019-11-26T15:42:58Z

Converting text to numbers

← Older revision		Revision as of 15:42, 26 November 2019
Line 7:		Line 7:

	==Converting text to numbers==		==Converting text to numbers==
	When imported data in an excel has ~~the~~ columns with number values alligned to the ~~right~~, this usually means the numbers are interpreted as text. In the following article from Microsoft it is explained how to easily convert columns with text to numbers:		When imported data in an excel has columns with number values alligned to the left, this usually means the numbers are interpreted as text. In the following article from Microsoft it is explained how to easily convert columns with text to numbers:
	[https://support.office.com/en-us/article/convert-numbers-stored-as-text-to-numbers-40105f2a-fe79-4477-a171-c5bad0f0a885 Convert numbers stored as text to numbers]		[https://support.office.com/en-us/article/convert-numbers-stored-as-text-to-numbers-40105f2a-fe79-4477-a171-c5bad0f0a885 Convert numbers stored as text to numbers]

2019-11-26T15:12:21Z

← Older revision		Revision as of 15:12, 26 November 2019
Line 1:		Line 1:
	Microsoft Excel and other spread sheet programs are known to be able to read many data types, however, sometimes this data is interpreted differently ~~that~~ desired. Below are tips to convert/ process data in spread sheets after import and prior to further processing in the Tygron Platform.		Microsoft Excel and other spread sheet programs are known to be able to read many data types, however, sometimes this data is interpreted differently than desired. Below are tips to convert/ process data in spread sheets after import and prior to further processing in the Tygron Platform.

	==Importing text as numbers in the legacy Import Text wizard in Office 2019 and up==		==Importing text as numbers in the legacy Import Text wizard in Office 2019 and up==

2019-11-26T15:10:10Z

← Older revision		Revision as of 15:10, 26 November 2019
Line 1:		Line 1:
	Microsoft Excel and other spread sheet programs are ~~knwon~~ to be able to read many data types, however, sometimes this data is interpreted differently that desired. Below are tips to convert/ process data in spread sheets after import and prior to further processing in the Tygron Platform.		Microsoft Excel and other spread sheet programs are known to be able to read many data types, however, sometimes this data is interpreted differently that desired. Below are tips to convert/ process data in spread sheets after import and prior to further processing in the Tygron Platform.

	==Importing text as numbers in the legacy Import Text wizard in Office 2019 and up==		==Importing text as numbers in the legacy Import Text wizard in Office 2019 and up==

2019-09-30T11:03:35Z

Removing spaces and other characters in bulk from ranges of cells

← Older revision		Revision as of 11:03, 30 September 2019
Line 13:		Line 13:
	Sometimes extra redundant spaces or other characters are found in (imported) cells that hinder proper interpretation of the cell value. By using the search and replace functionality this can be dealt with.		Sometimes extra redundant spaces or other characters are found in (imported) cells that hinder proper interpretation of the cell value. By using the search and replace functionality this can be dealt with.

	{{Editor steps\|title=remove redundant spaces from imported data in ~~Microsoft excel~~\|Select the cell (range) affected\|Select Start\|Select Edit > Replace\|Enter a space in the search field\|Leave the replace field empty\|Select Replace All}}		{{Editor steps\|title=remove redundant spaces from imported data in a work book or spread sheet\|Select the cell (range) affected\|Select Start\|Select Edit > Replace\|Enter a space in the search field\|Leave the replace field empty\|Select Replace All}}

	<gallery>		<gallery>