Hello ! I have a problem, due to excel seeing a cell as text by prefixing that text with an apostrophe, i need a solution how to add an apostrophe automatically to all cells at once. I have about 2500 lines and I don't really want to enter it manually for each one. Thanks in advance

And the convert to text function =TEXT(A1, 0) is not enough?

I haven't tried... I'll check and let you know. Thanks for the help

I'd like to run the following function in VBA: Code: text Expand Select all Copy to clipboardFunction apostrof() For i = 1 To 30 For j = 1 To 5 Cells(i, j).Value = Chr(39) + CStr(Cells(i, j).Value) Next j Next i End Function Of course, the range for i, j is set according to your needs.

imminent Have you tried activating this function? Added: For simplicity, I'll add that it should be Sub and not Function. Correct me if I'm wrong.

[EXCEL] Add Apostrophe to All Cells at Once: Efficient Solution for 2500+ Lines Input

Reply | New topic

#1 8289731 14 Jul 2010 00:38

Marcin_Sk Marcin_Sk

Level 10

» |

Post #1
8289731 14 Jul 2010 00:38

Hello !

I have a problem, due to excel seeing a cell as text by prefixing that text with an apostrophe, i need a solution how to add an apostrophe automatically to all cells at once. I have about 2500 lines and I don't really want to enter it manually for each one. Thanks in advance
ADVERTISEMENT
#2 8289969 14 Jul 2010 08:37

marcinj12 marcinj12

Level 40

» | Helpful post? (+4)

Post #2
8289969 14 Jul 2010 08:37

And the convert to text function =TEXT(A1, "0") is not enough?
ADVERTISEMENT
#3 8290091 14 Jul 2010 09:34

Marcin_Sk Marcin_Sk

Level 10

» | Topic author Helpful post? (0)

Post #3
8290091 14 Jul 2010 09:34

I haven't tried... I'll check and let you know. Thanks for the help
ADVERTISEMENT
#4 8296917 15 Jul 2010 23:06

wrych wrych

Level 20
» | Helpful post? (0)

Post #4
8296917 15 Jul 2010 23:06

I'd like to run the following function in VBA:

Code: text Expand Select all Copy to clipboard
Function apostrof() For i = 1 To 30 For j = 1 To 5 Cells(i, j).Value = Chr(39) + CStr(Cells(i, j).Value) Next j Next i End Function

Of course, the range for i, j is set according to your needs.
#5 8367675 05 Aug 2010 14:36

walek33 walek33

Level 29

» | Helpful post? (+4)

Post #5
8367675 05 Aug 2010 14:36

imminent
Have you tried activating this function?

Added:
For simplicity, I'll add that it should be Sub and not Function. Correct me if I'm wrong.
Create an account, log in and become active in a forum and ads will not appear. You will receive points by participating in discussions.
Join this discussion.

Install the application

Didn't find an answer? Ask Artificial Intelligence

*I agree to send the question to OpenAI, Anthropic PBC, Perplexity AI, Inc., Kagi Inc., Google LLC - owners of language models in order to prepare the best response. The companies may monitor and log information entered into the form.

*I agree to publicly display my question and answer. The question and answer will be publicly available to everyone. The process may take a few minutes. Upon completion, you will be redirected to the page with the answer.

Wait...(2min)

Reply | New topic

Report a violation of the law

[EXCEL] Add Apostrophe to All Cells at Once: Efficient Solution for 2500+ Lines Input

Didn't find an answer? Ask Artificial Intelligence