Now to see if the upload works.

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

Oct 18, 2024
7:05:12am

JayOwen Ah dinnae ken

Now to see if the upload works.

Report problem with this ad

JayOwen

Previous username: Kirkintilloch
Bio page: JayOwen
Joined: Jul 31, 2004
Last login: Dec 23, 2024
Total posts: 42,510 (27,394 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

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

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