How can I add a "close quote" mark AFTER each entry to a LONG column of numbers?

		Microsoft Office Forums > Microsoft Excel > Excel
How can I add a "close quote" mark AFTER each entry to a LONG column of numbers?

07-13-2022, 08:16 AM

Steve Kunkel Steve Kunkel is offline

Windows 10 How can I add a "close quote" mark AFTER each entry to a LONG column of numbers?

Office 2019

Advanced Beginner

Join Date: May 2019

Location: Seattle area

Posts: 81

Depending what you want to do with the values, you could also have an additional column next to your existing one, that has, for example

Code:

=A1&"""

The cells with the double quote mark would no longer be "numbers" though, so you wouln't be able to do math with them (average, etc).

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Split apart "page break" and "paragraph mark"	EwenMc	Word	4	10-03-2021 02:12 AM
One page in a document has a "full" or "long" Footnote Separator. It's only this one page, I'm lost.	taddpoal	Word	5	05-10-2020 04:07 PM
"Magic" indentation for "too-long" text-lines that are longer than one line	pGrnd	Word	2	04-20-2020 03:23 PM
Formula to format "I" column based on if "F" column row is not blank	ravl13	Excel	3	08-22-2017 12:26 PM
Need help with conditional formatting & returning "Pass" / "Fail Results" in a Column N	mikey386	Excel	2	12-11-2014 01:14 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:05 PM.