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
8:13
:39
am
PabloSanchezz
Starter
ChatGPT is the best Excel helper ever. Type in your question and it will give
you crystal clear directions, formulas to copy/paste and other considerations
Start a related thread
Start a related poll
Reply via Boardmail
Report problem with this ad
PabloSanchezz
Previous username
Young8
Bio page
PabloSanchezz
Joined
Sep 14, 2016
Last login
Oct 18, 2024
Total posts
853 (1 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
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
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