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

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:27:18am

RealSimsShadY All-American

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

Report problem with this ad

RealSimsShadY

Previous username: Max and I Hate U
Bio page: RealSimsShadY
Joined: Sep 15, 2016
Last login: Oct 18, 2024
Total posts: 17,535 (4,442 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

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

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