Thank you Guys, it work.

Sign up, and you'll be able to customize your font size and more! Sign up

Report problem with this ad

Oct 18, 2024
7:02:18am

JayOwen Ah dinnae ken

Thank you Guys, it work.

Report problem with this ad

JayOwen

Previous username: Kirkintilloch
Bio page: JayOwen
Joined: Jul 31, 2004
Last login: Jan 11, 2025
Total posts: 42,553 (27,432 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

10/18/24 6:43am

In the cell next to the first row: ="*"&A1 (A1 being the cell reference that has the text) then copy down

10/18/24 6:45am

This is the way

gww687

10/18/24 6:46am

That didn't work for me, without doing =CONCAT like silent_T mentioned below

JayOwen

10/18/24 7:01am

CONCAT(“*”, A1)

silent_t

10/18/24 6:47am

Or create a custom format and add it as part of the formatting

trueblueinarizona

10/18/24 6:54am

Thank you Guys, it work.

JayOwen

10/18/24 7:02am

Now to see if the upload works.

JayOwen

10/18/24 7:05am

Didn't work the way I wanted. The import included both answers, including the hidden column.

JayOwen

10/18/24 7:42am

also could have copied your column with the "*" and then pasted special the contents. Then delete the original column

trueblueinarizona

10/18/24 10:48am

True, but I didn't think of that.

JayOwen

10/18/24 11:43am

I usually add a ' before to stop the formula from trying to run

10/18/24 7:27am

ChatGPT is the best Excel helper ever. Type in your question and it will give

PabloSanchezz

10/18/24 8:13am

Where is the fun in using ChatGPT when I can let CBers show off their hard earned knowledge.

JayOwen

10/18/24 11:44am

I use it daily (for more than excel) and am a big fan of it

PabloSanchezz

10/18/24 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