Hi,
I have like 400000 cells with different text into it. But i would like to add 1 word to all those 400000 cells.
Do you have vba-code for this problem.
Thnx
Hi,
I have like 400000 cells with different text into it. But i would like to add 1 word to all those 400000 cells.
Do you have vba-code for this problem.
Thnx
Can you please show some examples of your requirement?
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
If it is the same word you need to add and all are in one column, I would recommend putting in a different column
=CONCATENATE(A1," ","___")
Where the ___ is you would put your word, then replicate the formula, and copy & paste the values over the top.
Perhaps (not tested)
VBA for adding specified text at the beginning of each cell
VBA for adding specified text at the end of each cellPlease Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks