My Account
Sign up, and you can make all message times appear in your timezone.
Sign up
Report problem with this ad
Start a related thread
Start a related poll
Reply via Boardmail
Oct 18, 2024
11:44
:25
am
JayOwen
Ah dinnae ken
Where is the fun in using ChatGPT when I can let CBers show off their hard earned knowledge.
I totally forgot about ChatGPT since I don't have to use it very often.
Start a related thread
Start a related poll
Reply via Boardmail
Report problem with this ad
JayOwen
Previous username
Kirkintilloch
Bio page
JayOwen
Joined
Jul 31, 2004
Last login
Oct 18, 2024
Total posts
42,219 (27,173 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
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
6:45am
This is the way
gww687
6:46am
That didn't work for me, without doing =CONCAT like silent_T mentioned below
JayOwen
7:01am
CONCAT(“*”, A1)
silent_t
6:47am
Or create a custom format and add it as part of the formatting
trueblueinarizona
6:54am
Thank you Guys, it work.
JayOwen
7:02am
Now to see if the upload works.
JayOwen
7:05am
Didn't work the way I wanted. The import included both answers, including the hidden column.
JayOwen
7:42am
also could have copied your column with the "*" and then pasted special the contents. Then delete the original column
trueblueinarizona
10:48am
True, but I didn't think of that.
JayOwen
11:43am
I usually add a ' before to stop the formula from trying to run
RealSimsShadY
7:27am
ChatGPT is the best Excel helper ever. Type in your question and it will give
PabloSanchezz
8:13am
Where is the fun in using ChatGPT when I can let CBers show off their hard earned knowledge.
JayOwen
11:44am
I use it daily (for more than excel) and am a big fan of it
PabloSanchezz
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