Excel Add ^ to a row of cells containing letters


Joined
Feb 23, 2018
Messages
67
Reaction score
24
I have a row of cells containing various letters.

A1:d B1:E C1:R D1:M and E1:is empty. This goes on to AL1:

I want add the symbol ^ to every(or a selection) cell(s) including blanks from A1 to AL1 all at once.

So it shows D^ E^ etc...

Also I would need to remove ^ as well.

Is this possible?
 
Ad

Advertisements

Becky

Webmistress
Joined
Mar 25, 2003
Messages
7,424
Reaction score
1,511
If you want to pull the information into another cell and add the ^ symbol then you can do that using the concatenate formula, but if you want to edit the contents of those cells, you will need to use VBA. I'm guessing it's the latter, and unfortunately I'm rubbish at VBA! I really should learn it, there have been a lot of queries recently where it would be helpful.
 
Joined
Feb 23, 2018
Messages
67
Reaction score
24
Hi

Thank you. It is the latter and VBA is not my thing either.

I am looking for a way to countif a range of columns but ignore certain lines. So D would be counted but D^ would be ignored. But because the size of the spread sheet it is impractical to add ^ to every cell manually.
 
Ad

Advertisements

Joined
Nov 4, 2017
Messages
5
Reaction score
0
Use the concatenate function to add that character to every cell and drag it down to get all of them. then copy the results and paste values over the original.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top