My Account
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
Dec 24, 2024
Total posts
882 (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
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