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

Oct 18, 2024
7:42:18am

JayOwen Ah dinnae ken

So I moved the contents of that column to a new worksheet and using =CONCAT("*",Sheet2!E2) worked.
It only imported from the first worksheet.

Thanks all for your help.

Report problem with this ad

JayOwen

Previous username: Kirkintilloch
Bio page: JayOwen
Joined: Jul 31, 2004
Last login: Oct 18, 2024
Total posts: 42,214 (27,170 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

Clark Addison

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

RealSimsShadY

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