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

Report problem with this ad

Oct 18, 2024
10:48:51am

trueblueinarizona Starter

Report problem with this ad

trueblueinarizona

Bio page: trueblueinarizona
Joined: Sep 6, 2002
Last login: Dec 24, 2024
Total posts: 958 (22 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