My Account
Sign up, and you'll be able to ignore users whose posts you don't want to see.
Sign up
Report problem with this ad
Start a related thread
Start a related poll
Reply via Boardmail
Oct 18, 2024
6:47
:33
am
silent_t
All-American
CONCAT(“*”, A1)
Replace A1 with the cell you want appended to the asterisk.
Now you’ll have a column that looks like what you want. You can copy/paste values to overwrite the original column if you want to
Start a related thread
Start a related poll
Reply via Boardmail
Report problem with this ad
silent_t
Previous username
(Private)
Bio page
silent_t
Joined
Mar 5, 2013
Last login
Dec 23, 2024
Total posts
1,756 (202 FO)
Report problem with this ad
Messages
Author
Time
Before I Google it, I thought I'd ask CougarBoard excel Gurus. Is there a way to add an * before the content
JayOwen
Ah dinnae ken
Oct 18, 6:43am
In the cell next to the first row: ="*"&A1 (A1 being the cell reference that has the text) then copy down
Clark Addison
Oct 18, 6:45am
This is the way
gww687
Oct 18, 6:46am
That didn't work for me, without doing =CONCAT like silent_T mentioned below
JayOwen
Oct 18, 7:01am
CONCAT(“*”, A1)
silent_t
Oct 18, 6:47am
Or create a custom format and add it as part of the formatting
trueblueinarizona
Oct 18, 6:54am
Thank you Guys, it work.
JayOwen
Oct 18, 7:02am
Now to see if the upload works.
JayOwen
Oct 18, 7:05am
Didn't work the way I wanted. The import included both answers, including the hidden column.
JayOwen
Oct 18, 7:42am
also could have copied your column with the "*" and then pasted special the contents. Then delete the original column
trueblueinarizona
Oct 18, 10:48am
True, but I didn't think of that.
JayOwen
Oct 18, 11:43am
I usually add a ' before to stop the formula from trying to run
RealSimsShadY
Oct 18, 7:27am
ChatGPT is the best Excel helper ever. Type in your question and it will give
PabloSanchezz
Oct 18, 8:13am
Where is the fun in using ChatGPT when I can let CBers show off their hard earned knowledge.
JayOwen
Oct 18, 11:44am
I use it daily (for more than excel) and am a big fan of it
PabloSanchezz
Oct 18, 12:08pm
Report problem with this ad
Posting on CougarBoard
In order to post, you will need to either
sign up
or
log in
.
Report problem with this ad